What will be the sql query to list the employee names those
are getting 3rd highest salary ?
Answer / Samar Jeet Yadav
You can use a SQL query with subqueries and ranking functions like this:nWITH RankedEmployees AS (SELECT *, ROW_NUMBER() OVER(ORDER BY Salary DESC) as Rank FROM YourTable)nSELECT Name FROM RankedEmployees WHERE Rank = 3
| Is This Answer Correct ? | 0 Yes | 0 No |
Difference between software process model and software process.?
What is a decade?
what is the difference betweeen far pointer and near pointer
why there is a collision in switch
What will be the sql query to list the employee names those are getting 3rd highest salary ?
what is the differences between software engineering and other engineering disciplines.
defference between menu and context menu in vb.net?
the conditional jump instruction in 8086 have a displacement of more than 1 byte.explain how would you tackle a situation in which it is required to branch,on some condition,to a location which is more than 120 bytes away.
Write a nonrecursive routine to reverse a singly linked list in O(N) time.
4 Answers Aptech, College School Exams Tests, IIIT, Infosys, KL University, SRM,
wats the difference between RS latch using NAND n NOR gate? which is to be preffered?
how to create session in visual web jsf page as we create in jsp and how to maintain that jsf session in another jsp page? <JSF=java server faces> <JSP=java server pages>
give me some knowledge about automation on which asked on interview
Civil Engineering (5086)
Mechanical Engineering (4453)
Electrical Engineering (16638)
Electronics Communications (3918)
Chemical Engineering (1095)
Aeronautical Engineering (239)
Bio Engineering (96)
Metallurgy (361)
Industrial Engineering (259)
Instrumentation (3014)
Automobile Engineering (332)
Mechatronics Engineering (97)
Marine Engineering (124)
Power Plant Engineering (172)
Textile Engineering (575)
Production Engineering (25)
Satellite Systems Engineering (106)
Engineering AllOther (1379)