Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Write a query to find second highest salary of an employee.

Answer Posted / khurram

The Simplest, easy, Understandable solution is

select max(sal) from emp where
sal not in
(select distinct Top 1 sal from emp order by sal desc)


Go Check Out for yourself
[replace "top 1" by "top 2" to get 3rd highest sal]
[replace "top 1" by "top 3" to get 4th highest sal] so on..

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell us which package can be imported while working with webdriver?

1051


What you know about table-driven testing?

1091


What are different coverages in function testing?

1141


hi every one this is ashok pls any one give answer me pls question is while testing with selenium after giving id user name and password , the inbox will be open , how to handle this one

2122


4. How we implement Winrunner,in our project?

2463


Write a short compiled module which selects random numbers?

1075


i need test cases for defect maganement tools

2056


I am testing a GIS based application so Can anyone tell me which automation testing tool is best for this application?

2904


Tell us how do you get the width of the textbox?

974


How would you test your own element locator?

1021


Anyone have idea of jmeter.IF so pls contact to this mail id arun130887@hotmail.com

1986


how to test an webbased application?

2053


Tell us how to login into any site if it's showing any authentication pop-up for username and password?

985


List some advantages and disadvantages of automation testing.

929


Hi, I want to learn DataBase Testing. So please some document or path so that i can get some material on DataBase Testing concepts (preferably SQL Server 2000). Thanks in advance, Guru

3787