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

Explain the third normal form(3nf)?

891

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1014

Can you index views?

847

How extra digits are handled with numeric data type literals?

904

What is an identity column in insert statements?

966

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

986

How to create a simple stored procedure in ms sql server?

971

Explain nested join?

921

Explain about builtinadministrator?

984

Write an SQL query to obtain the 2nd highest salary.

1018

Which tcp/ip port does the sql server run on? How can it be changed?

990

List some advantages and disadvantages of stored procedure?

964

What protocol does sql server use?

880

What is a trigger in sql server?

1085

What is the purpose of optimization?

948