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
- 31754 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 is the use of attributehierarchyvisible ? : sql server analysis services, ssas
What are the advantages of using a stored procedure?
What do you mean by sql server 2005 express management tools?
your distribution database is full what will u do
Does index speed up select statements?
How to loop through result set objects using mssql_fetch_array()?
What is data set in report?
What are the differences between char and varchar in ms sql server?
Can primary key be a foreign key?
How to set database to be single_user in ms sql server?
Can we insert data into view sql server?
What is the difference between primary key and unique constraints?
Mention the differences between local and global temporary tables.
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
What is difference between views and tables?
