can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com

Answer Posted / arun kumar ks

In the case more than one highest SALARY, only the Dilip’s
answer is correct.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how many clustered indexes can be created on a table? : Sql server database administration

559


Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

106


Can we install sql server 2016 on windows 7?

664


What do you understand by a stored procedure?

593


How to drop existing views from a database in ms sql server?

521






Explain having clause and where clause?

562


How to loop through result set objects using mssql_fetch_array()?

533


Difference between DELETE and TRUNCATE?

607


What is the difference between web edition and business edition?

88


how do you test proper tcp/ip configuration windows machine? : Sql server database administration

513


What are the essential components of sql server service broker?

556


How to select all columns of all rows from a table with a select statement in ms sql server?

565


What is the difference between commit and rollback?

492


What is the default sql server instance name?

554


How to use "begin ... End" statement structures in ms sql server?

514