Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 128797 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
Explain me what is the difference between setspeed() and sleep() methods?
What steps are needed in developing and running a software test?
What do you think holds the testers back to do automation? Is there a way to overcome it?
Please name a couple of standard web function found in the function generator?
It is a 30 days project & the client is in Singapur and we have to submit daily report regarding 1) What are the completed works, 2) What are the Pending Works ,3) Work planed for next day. You are free to assume regarding the project. can anybody help me to write an email to the client or Senior person who is staying in abroad
Name some of the commonly used automation testing tools that are used for non-functional automation.
I am new to jmeter and i am working on .net application.I am recording the requests and pop up images data are not recording.can some one suggest an idea regarding this
Is automation testing a black box testing or white-box testing?
What is tsl?
Explain me which web driver implementation is the fastest?
What is meant by the automation framework?
What is the difference between continue and next sentence?
What COM Interfaces u r using in QTp While Connecting QC or TD? Or in QTP?Any body plz urgent...
What are the attributes of a good framework?
What is the process of Automation Testing?
