how 2 find out nth salary.plz write sql qurires

Answer Posted / suresh yadav

select * from emp where &n=(select count(distinct(sal))from
emp b where emp.sal<=b.sal);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which is the best book to ref. for design the test cases/scenario in manual testing,which gives detailed idea with all the strategies ?

5963


what types of testing you performed in transfer funds module....

1178


Password is having 6 digit alphanumeric then what are the possible input conditions?

702


What do you think the role of test-group manager should be? Relative to senior management?

1672


What is coverage and what are the different types of coverage techniques?

656






Does anyone have any good examples of some acceptance criteria for non-functional requirements?

1549


Can test condition,testcase and testscript help u in performing the static testing

1613


Hi, This is vkram.I had completed my B.E in May 2005 & currently i am undergoing Testing Course. I want to join as a Fresher in any MNC. What should I tell why u r coming to testing field & what u did this 2 years?

1526


What is an inspection in software testing?

676


What are the different levels of manual testing?

676


what is JAVA TESTING? What Testers will do in JAVA Testing. Can any one Give suitable Ans Pls. it's urgent

1585


What is Application Performance testing and Operational performance testing

1582


What is Independent Testing?

1605


Hi, Please can one tell me how to test the usability testing, which method has to be used, how to write the report? Thanks Deepa

1591


Write the 10 high test cases for making video call/face time?? Write the test cases for credit card accessing the money transfer?? Write the test cases for file transfer from one user to other from Google Drive/drop box?

3645