select max(sal) from emp where sal !=(select max(sal) from emp);

write the query for find the top 2 highest salary in sql
server

Question Posted / pari

Answer Posted / pari

select max(sal) from emp
where sal !=(select max(sal) from emp);

Is This Answer Correct ?

5 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Is a primary key unique?

1035

can we have a nested transaction? : Sql server database administration

1188

Mention the uses of stored procedures.

1006

System variable and temporary variables

2297

What is sql collation?

1267

What are group functions in query statements in ms sql server?

1063

What do you understand by sql server agent?

1026

Can the “if update (colname)” statement be used in a delete trigger?

1032

What happens if we shrink log file in sql server?

1030

How many tables can be joined in SQL Server?

1111

What is difference between after and before?

1187

What are parameterized reports?

204

Can one drop a column from a table?

1067

Why are sql functions used?

1181

How can I tell if sql server is 32 or 64 bit?

1010