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 / bhaskar reddy thamma

SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT
(DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

suggest me the free online books on software testing?

1892


if we are using an Engine (tool)..with that how to capture data from excel sheets and how to do automation with this plz answer any body for this question.?

2096


what is GDC

2156


Tell me what databases can test director reside on?

921


Please explain how to perform load-testing?

1059


notice the distinction between data driven testing and retesting?

972


Explain what is the difference between findelement () and findelements ()?

1003


How software testing is handled?

961


can anyone suggest me any low cost tool that can support both Manual and Automation testing ?

1967


hi, I want to study TIA portla V11. where can I get online courses?

1890


What is Ticketing tool? Has it any other names? What is the purpose of this?

2057


Give some examples for functional & regression test tools?

947


What is ‘good code’? What is ‘good design’?

981


Could any one share scripts... where we can Parameterize radio buttons and Check boxes in Rational Robot.

2074


Do you know what is the purpose of deselectall() method?

1025