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
- 31712 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / kavitha.r
This query is generalised query if u replace 2 by 100 ,
then you will get 100th max salary
select top 1 salary from employee where salary in( select
top 2 salary from employee order by salary desc) order by
salary asc
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How to assign null values to variables or columns?
how to determine the service pack currently installed on sql server? : Sql server database administration
What is mean by candidate key?
What is tempdb in sql server?
What is implicit cursors?
What are the different types of replication you can set up in sql server?
Write the syntax for stuff function in an sql server?
What are the disadvantages of using the stored procedures?
What do you understand by the denormalisation?
What is candidate key with example?
How do I view a stored procedure in sql server query?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
How to add an address record into adventureworkslt?
Explain about Views?
How to encrypt Strored Procedure in SQL SERVER?
