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 the difference between deallocate cursor and close cursor?

1253

how you can deploy an ssrs report?

178

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1944

How the authentication mode can be changed?

1126

What do you know about system database? : SQL Server Architecture

981

Determine when to use stored procedure to complete sql server tasks?

1052

What are the advantages of user-defined functions over stored procedures in sql server?

1036

Describe the functionalities that views support.

1097

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1210

What is triggers and stored procedures?

938

Explain the cursor lock types?

1048

Can foreign key be duplicate?

1056

What does it mean to normalize data?

936

How do I find information about the install locations for the various instances running on a computer?

1076

How to disable triggers using "disable trigger"?

1056