how 2 find out nth salary.plz write sql qurires

Answer Posted / rafi

Select * from (Select emp.*.dense_rank()over (order by sal
desc) a from emp) where a=&n;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the Difference between Network testing and Web Testing?

1730


how to generate id in testdirector? a) Td id 1 b) td id 2 c) td id 3 d) td id 4 which is correct answer please any one of the tell me and mail me

1801


can you show me the test cases on registration form

1230


Diffrernce between client server testing and web server testing.

1743


In which all places, testing is done?One is from the server by calling server name.Can u suggest others?

1482






Can any one share the domain knwoldege of Telecom Jeeva jeevachr@gmail.com

2054


There is only requirements document. You have 10 days and 8 resources to release the system.At the end of the 8th day u tell ur TL that system is ready for release. How will you proceed with the testing process or in other words what all approach you will follow once you get requirements

1581


What is stub?

695


What do you understand by usability testing?

660


What is Bomb Testing?

1766


IN SQL SERVER 2005, With out using Query, hw can u break down USER NAME & PASSWORD to enter the software.

1730


What is meant by Boundary value analisis and Equalence partitioning? Can give derive this using these methods? In a system designed to work out the tax to be paid: An employee has £4000 of salary tax free. The next £1500 is taxed at 10% The next £28000 is taxed at 22% Any further amount is taxed at 40% Which of these groups of numbers would fall into the same equivalence class? a) £4800; £14000; £28000 b) £5200; £5500; £28000 c) £28001; £32000; £35000 d) £5800; £28000; £32000

1593


uses of checklist

1524


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?

9086


how deployment phase of SDLC differs in product based and in service based company ?

2542