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

How to delete multiple rows with one delete statement in ms sql server?

1031

What are the different acid properties?

1075

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

936

Explain the stored procedure?

1057

What is indexed view? How to create it?

1023

How many columns can we include on clustered index ?

999

What is federation member?

116

Do you know what is difference between index seek vs. Index scan?

959

Explain filtered indexes benefits?

1010

Can you type more than one query in the query editor screen at the same time?

1015

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

916

How can you know if the row fetched from cursor is still valid in underlying table?

1002

Why use view instead of a table?

957

How to assign new column names in a view?

925

Can you move the resources after pausing the node? : sql server database administration

1111