select top 1 * from (select distinct top 2 * from emp order by sal desc)t

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 / lince

6 Answers
8003 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which are the important points to note when multilanguage data is stored in a table?

970

Can I work with several databases simultaneously? : sql server management studio

968

Can I run multiple instances of sql server 2000 at the same time on one computer?

1058

Can you name some of the dml commands in sql?

1007

Explain transaction server isolation?

1004

What is buffer cash in sql server?

1138

How to create a new table in a given schema?

1164

What are data files?

1020

What is log shipping?

945

What are subqueries in sql server? Explain its properties.

993

What are .mdf files?

920

Give me a SQL Query to find out the second largest company?

1147

Where in ms sql server is ’100’ equal to ‘0’?

1060

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

310

What is a dbms wizard?

999