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 |
What is primary key and example?
Write SQL queries on Self Join and Inner Join.
What is the difference between truncate and delete statement?
6 Answers CarrizalSoft Technologies, CTS,
Some queries related to SQL
What are the filtered indexes?
What is named query? : sql server analysis services, ssas
Different Types of Functions ?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
How to update a field in SQL after ALTERING a row?
What is nested transaction?
What according to you is the difference between mysql and sql server performance?
could u plz explain about joins and views?