select salary from emp where rowno=3 order by sal desc. but this query w

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

Question Posted / priyanka

Answer Posted / priyanka

select salary from emp where rowno=3 order by sal desc.

but this query works only when you have to create index.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is meant by dirty read?

1041

Tell me what is use of except clause? How it differs from not in clause?

995

Explain Reporting Life Cycle?

132

Can a table be moved to different filegroup?

1025

What is usually the first word in a sql query?

1174

Explain primary key?

1005

What is an expression in ms sql server?

1141

Can we insert data if clustered index is disabled?

986

What are the disadvantages of using querystrings to send data from one page to another?

1071

Explain for xml explicit mode?

1024

Define compound operators?

964

how you can list all the tables in a database?

1067

How to select true false based on column value in sql server?

1082

What are the different types of stored procedures?

1155

Why use view instead of a table?

1003