can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 27848 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / rajendra
Select Top 1 * From Tablename where salary in
(select top 2 salary from tablename order by salary desc)
order by salary asc
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Write a sql query to sort on different column name according to the parameters passed in the function?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
What are the difficulties faced in cube development? : sql server analysis services, ssas
What is the significance of master, tempdb and model databases?
Differentiate between a local and a global temporary table?
Explain filtered indexes?
How to check table values in sql server?
What is optimization and its types?
Define tool Manage Statistics in SQL Server 2000 query ?
What happens to a trigger with multiple affected rows?
Can one drop a column from a table?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
How to create “dependant” parameter “make, model, year”
How are the exceptions handled in sql server programming?
How do I start sql server 2016?
