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
- 32702 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
What happens if strings are casted into wrong code pages in ms sql server?
What is report rendering ?
What is merge join?
What are date and time data types in ms sql server?
Which table keeps information about stored procedures?
How to connect Azure federated root database and apply federation in entity framework?
What is change tracking in sql server?
What are the events recorded in a transaction log?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
what is a join? : Sql server database administration
What is checkpoint in sql server?
What are the kinds of subquery?
How to find index size for each index on table?
How to start and end transact-sql statements?
Can two tables share a primary key?
