can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
Answer Posted / neeru
I think Daleep answer is not so precise, if you want 3rd or
ny specified answer, this only can only be seems right for
2nd highest salary, else, its not optimise query.I found
Preeti's query more optimistic and accurate.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Distinguish between nested subquery and correlated subquery?
What happens if null values are involved in boolean operations?
What triggers long term care?
What is side by side migration in sql server?
What is a View ? Can we insert, Update and delete a view?
How efficient you are in oracle and SQL server?
What is cross join in sql server joins?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What are the disadvantages of primary key and foreign key in SQL?
How do I connect to sql server database?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
What is the bookmark lookup and rid lookup?
What is the difference between implicit and explicit transaction?
What is the need for group functions in sql?
Mention the different types of replication in sql server.