Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 130605 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / shahnawaz
please check this one .
first rank the salary coloum and then find nth heigest
salary
use rank function
select * from
(select a.*, rank()over(order by salary desc) rn from
emp_shah a)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can you switch back from a frame?
List out some of the automation tools which could be integrated with selenium to achieve continuous testing.
I want to learn the data base testing, how can I start my psactice? I already reading the books of basic for data base? If any other books that make my study simple please suggest.
Tell me what databases can test director reside on?
Why do you want to keep this kind of information in a separate file and not directly in the code?
How to decide the tool that one should use for automation testing in their projects?
what r the diffence between QTP 8.2 & QTP9.0?
Tell me how can we find the value of different attributes like name, class, value of an element?
What are the attributes of a good framework?
wat would be the -ve test case for search where u can brak it ,tell dnt tell abt spl characters insertion ,boundary values chk.
Tell us what you know about table-driven testing?
What is keyword driven automation?
Write a short compiled module which selects random numbers. and what function is used to call your customized compiled module?
What should you do after finding a bug?
How you report bug in to bugzilla
