Find 2nd Highest salery in emp table
Select* from emp where &n=
select * count from emp where (salery >=emp.salery)
Enter n value 2
These query is correct or not. Tell me any other methods.
Answers were Sorted based on User's Feedback
Answer / asimananda
SELECT MAX(SAL) FROM EMP WHERE SAL < ( SELECT MAX(SAL) FROM
EMP )
Is This Answer Correct ? | 7 Yes | 2 No |
Answer / kb
select top 1 * from emp
where sal < (select max(sal)from emp)
order by sal desc
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / lince
select top 1 * from (select distinct top 2 * from emp order by sal desc)t order by sal asc
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / r.rajivgandhi
Select max(salary) from emp where salary <(select max
(salary) from emp)
These Query is correct.Try It
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / madhu sudhan g
Hii lets consider the table Salary having EMPNO,EMPSal columns
to find the 2nd higest salary
;WITH CTE(Sal,Row)
AS
(
select EMPSal,ROW_NUMBER() OVER(ORDER BY EMPSal) as Row from Salary
)
select sal as Salary from CTE where Row=2
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ramu
by using sub quries we can do
select * from emp where sal=select max(sal) from emp where
sal<select max(sal) from emp;
Is This Answer Correct ? | 1 Yes | 2 No |
How do you simulate a deadlock for testing purposes
Difference between primary key and clustered index?
What are the types of joins in sql?
What does ss stand for sexually?
How to move database physical files in ms sql server?
Can we use Truncate command on a table which is referenced by FOREIGN KEY?
What is openxml in sql server?
What is an inner join?
How to create a new login name in ms sql server?
what changed between the previous version of sql server and the current version? : Sql server database administration
I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...
What is the difference between temp table and table variable?