Interested to Buy Any Domain ? << Click Here >> for more details...
can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 33524 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
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
Can a unique index be created on a column, which contains null?
What are the disadvantages of using querystrings to send data from one page to another?
Which are the two editions in which SQL Azure database available?
What is 'write-ahead log' in sql server 2000 ?
Tell me about builtinadministrator?
What is the difference between functions and stored procedures?
How to delete an existing row with delete statements in ms sql server?
Explain the different types of backups available in sql server? : sql server database administration
Explain about Views?
Can one drop a column from a table?
What is the synonym of join?
What is dbcc updateusage?
What are temporal tables in sql server 2016?
Tell me what is the difference between locking and multi-versioning?
Explain what is lock escalation and what is its purpose?
