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 / muralidhara(minchu)

Select * from epm A where &(n-1)=(select count(*) from emp
B where A.sal < B.sal);

Try this it will work,this will give nth salary ie if u
enter 2 this will give second highest sal

Is This Answer Correct ?    13 Yes 22 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where do we get the QTP and Load runner softwares CDs ( Original ) in chennai

2182


Tell us how can we handle web-based pop-up?

976


Tell us what is the alternate way to click on login button?

982


What is self-referencing constraint in mainframe development?

906


What is the major difference between Acceptance test , Functional test , Usability test and Performance test with special reference to auotomotive domain

1992


Can we prioritize tests in Junit. What is the sequence of execution in Junit?

1896


Explain some disadvantages to manual software testing?

1045


Hi, I wanted to go with TestingDomain-Automation. Regarding this I need to take training on any one tool either WinRunner or LoadRunner. Which is better to get job,having future and takes lesstime with easier***. pls mention one tool name. Basically iam manual test engineer on unix- platform.

1912


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

1005


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

3733


Tell me the fundamental difference between xpath and css selector?

1016


What all different approaches can be used for designing an automation solution?

874


Tell me how can the user get a text of a web element?

902


what is aom and how to add object repository? i am very new to QTP please help me

1889


what is the difference between keyword driven frame work and data driven frame work.

2274