Top 10 SQL Interview Question | Question With Answers | Most Asked Question| SQL Interview

[@soniayushmaan]

Hi in 06:25 you mentioned wrong salary as the highest. The highest one is 159000 but accidentally you termed 125000.

[@venkateswarluguditi8461]

He says second highest salary..

[@maheshmalekar6640]

@@venkateswarluguditi8461 Sir said in the video highest sal is 125000 and second highest is 112000 that's not correct Actually, 159000 is the highest and 125000 is the second highest.

[@shontyvlog]

Never give this ans in interview, this is not correct, ans should be like below. SELECT TOP 2 * FROM ( SELECT ROW_NUMBER () OVER (ORDER BY Salary DESC) AS RNUM1,* FROM TBL_ORDER ) AS TBL1 WHERE RNUM1 = 2

[@borntoplay5848]

For 2nd highest salary Select * from emp where salary=(select max(salary) from emp where salary < select max(salary)from empl));

[@abhishektiwari2092]

@@shontyvlog hi

[@manasasahoo6485]

Thank u so much for this vdo bro ❤️ from Puri, Odisha Jay Jagannath 🙏

[@PatelBhaveshgo4glory]

We can get any salary(2nd - 3rd - 4th) by using a simple query. For example, If you want the second highest salary then n = 2 SELECT * FROM `employee` ORDER BY salary DESC LIMIT 1 OFFSET (n-1);

[@step3roll805]

For 2nd highest salary Select* from employee where salary=(select max(salary) from student where salary

[@angrezikguruji5691]

Yesh

[@nileshmishra397]

Select* from emp where esal( select max(esal) from student where esal (select max(esal) from student) ;

[@sadanandjori7952]

You can use this - select e_salary from employee order by e_salary desc limit 1,1;

[@mukulupadhyay4656]

Very helpful video watched your OOPS video too thanks a lot.🙏

[@MEGAMINDLIVE]

we can also delete an entire row of a table by using the DELETE command. so row sequence is the main difference between DELETE and TRUNCATE.

[@mkbproduction]

Along with The very major difference is rollback can't be applied on truncate And truncate is faster

[@shreyash9357]

For second max salary Select * from tblemployee where salary=(select max(e_salary) from tblemployee where e_salary

[@shrutikorde3840]

I like your way of teaching or guiding...... It really understandable..Thanks Sir🙂

[@Kxlifts]

Thanks sir well explained , its to useful for me

[@mkbproduction]

Select max(select salary from employee where salary< max(salary)) as 2nd_max_salary;. This is also correct na??

[@awakenedsouls3206]

No ! First we will determine the inner query that will be select max salary from emp This way it will be first executed and max salary will be determined Then we will give an outer query That says Select max salary from emp where salary ( select max salary from emp ) This is the complete query as the solution In this first we determine the max salary and then we exclude it with the not equal to sign Now , in this way , if the max salary excluding the highest salary will be selected , that will be the second highest salary itself

[@mkbproduction]

@@awakenedsouls3206 thanks

[@gauravgholave]

Select max(e_salary) from employee where e_salary not in (select max(e_salary) from employee

[@cseengineer2724]

Sir How to prepare for interview to power programmer sir

[@Lifefocus-zg8ng]

Thx @mridul bor keep it up,good job👍

[@bhausogadade7659]

Second highest salary Select max(salary) from emp where

[@amankumaramar271]

Thank you so much sir g ❤️

[@CodePressAcademy]

Thanks a lot

[@only_soulful_lyrics]

You explained second highest salary wrong highest is 159000 and second is 125000

[@cseengineer2724]

Any paid course available sir give me some ideas

[@abhishek_j26]

Thanks.👌👍

[@arpitatiwari3073]

Nice 😊😊

[@karthikeyakagan4433]

Select won't comes under the DML... Select comes under DQL (Data Query Language)... First prepare well before doing vedios on SQL

[@mkbproduction]

The SELECT statement is a limited form of DML statement in that it can only access data in the database. It cannot manipulate data in the database, although it can operate on the accessed data before returning the results of the query.

[@ApnaRishabh]

First learn the spelling of "Videos" well before commenting in any video.

[@funcentral8199]

@@ApnaRishabh💀🤣🤣

[@I_am_smooth_as_butter]

@@ApnaRishabh 😂😂😂😂

[@rutukeshkashid5058]

DRL NOT DQL🤣🤣

[@pandu3320]

Hello sir. I have registered for Accenture Innovation Chllenge. Can you please suggest me some tips to win this challenge?

[@Deepratan27]

What is natural and cross join this is also ask by interviewer

[@TheBalanceLife]

Select command does not come under DML sublanguage come under DQL sub language

[@amrutapatil2251]

Thank you

[@vijendrabijalwan7936]

in case we wants to find 5th highest salary without subquery so can i find

[@SouravGhosh-nm8ph]

select top 1 * from(select top 5 salary from employees order by salary desc) order by salary asc;

[@NikhilKumar-yc5rt]

Nice explanation

[@simranbanwait]

thanks bhai

[@sankeerthananamoju]

good one

[@dark_legions2227]

Awesome..

[@swatichauhan3260]

Can i get some real scenario based questions. I want to know what type of queries are given and how to solve them

[@surajashware5058]

Telegram link not working.. brother

[@piyushpatil5898]

Bhaiyya Oracle Database 11G ka installation me problem aa raha hai please koi solution do na

[@Vinay-lb8px]

Sir 21st i have cognizant technical interview plz make video sir

[@technofreak-tl5zd]

Telegram link is not working urs kindly send again

[@Womenhealthchronicles]

What type of jobs can we apply for after learning sql

[@diya7502]

You can go for data analytics field

[@nileshmishra397]

U cal also learn in sql Html Basic than u can also apply in web developer for small it company

[@Cricket-Adda....]

Thank you bhai

[@SmartSimplified1]

Keep growing 👍

[@jiteshtakkar8813]

nice

[@mahalakshmi4220]

Thank u sir❤

[@agriculture.islife.6149]

please be make sure dont go this fast its to fast unable to understand you

[@Localplacesfromlocalpeople]

above questions - -Rdbms -Difference between order by and group by -pattern in a colm

[@nileshmishra397]

If u all are question ans available from utub Or google

[@sachinghutke9711]

I have a scenario based question could u solve

[@BTCIVArnavGaner]

my question here is that where cannot be used on aggregated data so how is it used here can anyone explain this?

[@NeerajSingh-ns7ts]

civil

[@dipankarsantra7785]

Telegram ade nahi ho raha he.

[@autojagatwithvineet3053]

👍👍👍

[@brijesh9452]

Sir clr nhi aata h jo typ krte h?

[@skmiraj6339]

Bhai Python ka v upload kardo

[@SmartSimplified1]

Sure

[@skmiraj6339]

@@SmartSimplified1 thank you bhai

[@ankushgupta8778]

😮😮

[@v.t.s.ramthulasi1093]

bro pls snd this question and answer pdff

[@jitendrajaintwal6503]

Dml ka to sab aata h pr baaki ni

[@hazardopop7378]

Tho jaake padh na

[@rojalibiswal8975]

Highest salary to 159000 hay app125000 kiun bole

[@Atulnavadiya]

Aiveyi video bna diya lagta hai isne.

[@vasantimisal3870]

hi can i get pdf of these question n answers?

[@Deepratan27]

group by and DBMS तो हवा में ही उड़ा दिया

[@floridan1238]

5:44 galat h

[@shekharkarande9866]

tjik se banaya kr vid

[@Sonamkhan]

Hello sir, 14may ko mera interview hai. C# Dot Net K LIYE profile select hui h kya question puchenge kuch b nhi malum pls help me.

[@sahilchauhan2489]

Yatharthrti mai kya

[@theindiatech8461]

Sir python ke bhi important question per bhi video bana do 🙏please

[@SmartSimplified1]

kzbin.info/www/bejne/eZ3Xp6p4mb6UiLs

[@AmanSharmaSem1]

Can anybody help me to get job based on sql?

[@Harsh-wz7lw]

Konse state se ho?

[@AmanSharmaSem1]

@@Harsh-wz7lw uttar pradesh

[@Harsh-wz7lw]

Apps or websites hoti h unpe apna resume daal do , mil jayegi koi na koi company

[@Harsh-wz7lw]

@@AmanSharmaSem1 m Chandigarh se hu agr yha ke hote to naam bta deta companies ke pr U.P se Chandigarh itni door kya job krni Vhi mil jayegi

[@techxtreme7630]

hello sir can you help me for a query I have a 3 column in one table like C1, C2, C3 I want all column values add in only one column C1 and also replace special character as space

[@abhijeetchougale3842]

Select column 1+'-'+cloumn2+'-'+column3 as column from table

[@madhavchavan7857]

PLEASE CHECK QUE .5 THIS WRONG ANS

[@prateeksaini7268]

share the ppt man

[@sannswaghmode]

Don't refer this video most of the concept explained in this video are wrong so don't misguide. Acquire proper knowledge before making video

[@swatichauhan3260]

Is someone working on sql? Plz help me

[@Rahulkumar-ij6sl]

Yes i am ...you can ask me any time

[@swatichauhan3260]

@@Rahulkumar-ij6sl i want to know how excel n sql works together like how to bring data to sql and after formatting, how to export it

[@DhanshreeTalekar-ld2tr]

Koi job hogi to dilva do

[@YesweMiddleclass]

Maximum salary galat hai

[@nileshmishra397]

Select*from emp where esal=max(esal) from emp student where esal

[@BholaG1984]

Max salary was 159k

[@venkateswarluguditi8461]

He says second 🥈 highest salary

[@sahajbharathydrofarm4314]

Aaà

[@unexploredindia199]

@mridul Your telegram channel link is not working

[@ankitkalwar5570]

Nicely explained, thank you so much

[@codewithdeepak45]

thanks bhai