how 2 find out nth salary.plz write sql qurires

Answer Posted / ganesh thik

select * from employee emp1 where 2=(select count (emp2.salary))from employee emp2 where emp2.salary>emp1.salary.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do submit teststrategy to customer if yes at what time

1549


1.What types of documents would you need for QA, QC, and Testing?

4922


How we will do Memory Testing? There is any tool to do that testing and to whome this testing to be performed?

1513


In interview How do explain in Testcase of Calcuator,Cellphones, Email testing?

1745


Explain the difference between severity and priority.

678






What is remedy testing,expalim that and how can use that

1241


How to explain the Insurance project in the interview?

1095


What is client server application testing?

1547


What icon is used in WinRunner to get an explanation of the syntax of TSL?

1567


Plz give me manual testing real test case ?

1032


14.What is function point breakdown?

2244


Can you explain the workbench concept?

708


. Is any graph is used for code coverage analysis?

2120


Explain test metric and the information it provides.

686


IF ASCII_CODE_OF_ENTERED_CHAR is less than 44 THEN reject it ELSE IF ASCII_CODE_OF_ENTERED_CHAR is greater than 56 THEN reject it ELSE it's a digit, so accept it Which one of the following sets of ASCII codes do you use to test the sample code above WITHOUT redundant coverage?

9084