select top 1 * from emp where sal < (select max(sal)from emp) order by

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.

Question Posted / kb

6 Answers
8006 Views
I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are the different types of SSRS reports?

151

Explain different types of lock modes in sql server 2000?

922

What happens when transaction log is full?

909

What is a select query statement in ms sql server?

1049

What do you mean by a Composite primary key?

1084

How does index makes search faster?

958

What is field with example?

906

Can you please explain the difference between function and stored procedure?

989

What are the different sql server versions?

962

What are the system database in sql server 2008?

1015

How to change the system date and time from SQL Plus Terminal ?

1199

What are the fixed server level roles? : sql server security

1105

What is collation sensitivity?

1039

What is use of dbcc commands?

1049

How we can compare two database data?

922