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 |
what is release notes?and when it is prepared and who prepares that?.
What is parallel Testing?
what is a horizontal and vertical matrix explain with examples
Does Automation replace Manual Testing?
define risk management system with example ?
Functional and Integration test scenarios for actitime application
What is meant by Metrices?What is purpose of Metrices in Testing?What is Template for that?PLZ REPLY ASAP.Thanks in advance.
What is meant by thin point in QTP
What r all the security problems u r facing & the measures taken to solve.
hi,i have just done a 3 days training in software testing,i read and to a certain limit understand the fundermentals but when it comes to real life scenerio i mean working on a job i dont think am confident in the practical aspect. if u feel me pls hola
what is the best defect(functionally relaleted) u find in u r career?
1Who performed sanity and smoke testing :-- developers or testers ? Explain with example and prove ur answer. 2 Company has developed a project for company B, company B has to introduce this project into the market. The acceptance testing is performed at Company B. is it called as alpha testing or beta testing ? Explain with example and prove ur answer.