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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the indexes in sql server?

477


Explain query editor regions

590


Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

558


What is tempdb in sql server?

487


What is difference between table aliases and column aliases? Do they affect performance?

490






What is ems sql management studio? : sql server management studio

561


How to convert binary strings into integers in ms sql server?

529


Mention the differences between local and global temporary tables.

544


Do you know what is sql service broker?

511


what are the different types of SSRS reports?

102


Can two tables share a primary key?

489


What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

114


What are sp_configure commands and set commands?

538


How you provide security to cube? : sql server analysis services, ssas

513


What is sql server profiler?

542