can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 27846 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
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 are database states in ms sql server?
How would you choose between a clustered and a non-clustered index?
How to find table changes in sql server?
Tell me something about security and sql azure?
Can you explain what is indexed view? How to create it?
What information is maintained within the msdb database?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
Write the SQL query to drop, truncate and delete table.
What is subquery? Explain the properties of a subquery?
Can one drop a column from a table?
what is package and it uses and how can u call a package
What it means to be triggered?
Explain security with sql azure?
How to truncate the log in sql server 2012? : sql server database administration
How to move database physical files in ms sql server?
