how 2 find out nth salary.plz write sql qurires
Answers were Sorted based on User's Feedback
Hi...
here is the query to find out the n'th maximum salary
note: 1.'emp' is Table name & 'sal' is column name.
2.'distinct' is used for finding the unique value
3.'count' is for counting the values.
Query:
------
SELECT * from emp
where sal = (SELECT distinct(sal) from emp x
where &n = (SELECT count(distinct(sal)) from
emp where sal >= x.sal));
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / guest
select top 1 salary from(select Distinct top 2 salary from
employee order by salary desc)order by salary
Is This Answer Correct ? | 1 Yes | 1 No |
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 |
Answer / 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 |
Hi, Can anybody send some test scenarios or testcases sample for Finance domain on sales and accounting application. I am very new to Finance domain. Or else please send to my mailID "manojdalai2004@gmail.com". Thanks in Advance, Manoj
What is srs and brs document?
Once automated, what are the types of functionality provides the highest Return On Investment (ROI) to the company?
What r the major problems faced in manual testing?
Write Test case on even/Odd or Prime Number from 1 to 100 ?
What is manual testing and what is it process?
who assigns siverity for a bug? is it test engnr, test lead or devlopment lead?
What is role of a tester in the requirement phase?
What is Test Design ?( Urgent) and Test Design for Printer?
Hi Friends, Please help me in providing System test cases examples Thanks in Advance
HOW DO U EXECUTE THE CASES WHEN THE TIME IS NOT SUFFICIENT TO EXECUTE ALL THE TEST CASES?
Suppose when you click on message icon in your mobile phone , if it is giving a message "Error,Message cannot be opened", Wha will u do? how do you rise a defect? /