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 is the difference between deallocate cursor and close cursor?
how you can deploy an ssrs report?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
How the authentication mode can be changed?
What do you know about system database? : SQL Server Architecture
Determine when to use stored procedure to complete sql server tasks?
What are the advantages of user-defined functions over stored procedures in sql server?
Describe the functionalities that views support.
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
What is triggers and stored procedures?
Explain the cursor lock types?
Can foreign key be duplicate?
What does it mean to normalize data?
How do I find information about the install locations for the various instances running on a computer?
How to disable triggers using "disable trigger"?