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

What is benchmark testing? hi friends... can anyone suggest the correct answer plz...

3196


What is the difference between a bug, a defect and an error?

694


Explain accessibility testing and its importance in the present scenario.

687


Hi,Please can any one tell me about SAP Testing concepts.

1553


1. what exactly is heuristic checklist approach for unit testing ?

2229






hi... guys can any one pls help me out.... I m civil engg graduate i want to come into s/w field... i have decided to do manual testing course. i know its not sufficient.. which r the other coures shall i do with this.. suggest me good atomation tool and SAP courses... thanks in advance.. i wil be thankfull to u all

1712


Can any one suggest how to write the bug reports effectively by optimizing what we want to describe?

1547


Did you ever worked with B.A's and when?

1621


Anybody having documents and URLs about BFSI domain...Please share..it is really urgent

1967


What types of documentation are used in qa?

681


What is test closure?

897


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

1587


What will be the QA roles and responsibilities in Health care stream like BCBS,can someone please explain me any example project regarding health care services in web-based application?

1689


What is a test server?

733


What is test management?

1440