how 2 find out nth salary.plz write sql qurires

Answer Posted / a sameer

By using alias name too we can generate the query
A and B are two alias name for the employee table name

Query:-

select A.* from employee A where N=(selet count(Distinct
B.sal) from employees B where B.Sal > A.sal);


If any one want 2 or any other salary jut replace "the no."
required in place of N, to get the answer.


Hope might understand

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is metrics in software testing? give me a brief detail about it?

4546


how to explain banking domain project in testing?

10605


Explain the defect life cycle.

819


What are the RBI rules has to follow by a bank for online precesseing. ?

1926


can you tell me how to write test cases for payments, receipts, inward clearing, outward clearing, A/c statements ?

1896


How do u prepare test environment for ur application?

1926


How soon the bug should get fixed?

877


What is the difference between load and stress testing?

975


What is smoke test? Do you use any automation tool for smoke testing?

896


explain ur testing project? how can u nexplain . what should we explain ? i have not worked on any project?

1979


sanity testing is done during regression testing.is it true.if it is true plz explain?

1707


What are differences between Testing in Uncontrolled Environment and Abnormal Environment?

2633


What is strategy to be followed for execution of 500 Test Cases in One day. If only 1 Resource is available.

1712


What is early testing?

863


Can you explain exploratory testing?

886