how 2 find out nth salary.plz write sql qurires

Answer Posted / kishore

SELECT [column_list], ROWNUM
FROM (SELECT [column_list]
FROM table
ORDER BY Top-N_column)
WHERE ROWNUM <= N

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how will u create diff types of scenario for any website?

1793


What is bucket testing?

660


what is the relation between all tabs in quality center & explain the testing process in quality center with tabs?

1586


can u write some high level scenarios on ms outlook express

2287


1.Tell me negative test cases for notepad 2.Tell me the factors for for writing severity based test cases

5544






What type of metrics would you use?

1746


Could some one tell me test cases for multi line text boxes like Notes field?

1701


PLEASE CAN ANYONE SEND ME THE TEST SCENARIO BASED QUESTIONS FOR 3+ EXPERIENCE IN MANUAL TESTING

3875


Which was the most interesting bug you found.

2470


How to explain the Insurance project in the interview?

1095


What impact ratings have you used in your projects?

683


I have 2 yr Localisation testing exp now i want to job in MNC My manualtesting knowledge+2 yr exp sufficiant for in MNC

1584


How many bugs occured will be considerd appropriate over 1000 steps when inspecting software? Describle an approriate Bug value.

1687


What are the uses of test plans? What is the need of test plans and explain their significance

1368


1) Difference between "Delete" and "Concatenate" with reference to databases? 2) Difference between SDLC and STLC. 3) Latest versions of the browsers used. 4) What is URL Tampering? 5) Full form of URL. I don't need the answers. These are just for reference.

1968