can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
Answer Posted / preeti chauhan
CREATE TABLE T1(SALARY int, [NAME] varchar(50))
SELECT TOP 1 SALARY FROM (SELECT TOP 2 SALARY FROM T1 ORDER
BY SALARY DESC)T1 ORDER BY SALARY
Is This Answer Correct ? | 15 Yes | 3 No |
Post New Answer View All Answers
What will be the maximum number of index per table?
What is xml datatype?
How to include text values in sql statements?
What is a non equi join?
What is sql collation?
What is set nocount on and what is set nocount off?
How to maintain a fill factor in existing indexes?
Explain the categories of stored procedure?
Which table keeps information about stored procedures?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
Where are stored procedures in sql server?
What is an identity column in insert statements?
Explain different types of locks in sql server.
What is the difference in accessing db between sql server vs sql azure?
In which format does an image save in SQL Server database ?