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
What are the indexes in sql server?
Explain query editor regions
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What is tempdb in sql server?
What is difference between table aliases and column aliases? Do they affect performance?
What is ems sql management studio? : sql server management studio
How to convert binary strings into integers in ms sql server?
Mention the differences between local and global temporary tables.
Do you know what is sql service broker?
what are the different types of SSRS reports?
Can two tables share a primary key?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
What are sp_configure commands and set commands?
How you provide security to cube? : sql server analysis services, ssas
What is sql server profiler?