can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
Answer Posted / darshan shah
select top 1 * from (select top 2 * from emp order by sal
desc ) a order by sal asc
Plz try this.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many columns can exist together per table?
What is the cpu pressure?
Mention the 3 ways to get a count of the number of records in a table.
How do I find the default sql server instance?
Do you know data definition language, data control language and data manipulation language?
what is a self join? Explain it with an example? : Sql server database administration
What is model database in sql server?
What is repeatable read?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
Which table keeps the locking information?
Can sql server 2016 run on windows 7?
Is mysql better than sql server?
Will count(column) include columns with null values in its count?
What are Row versions of DataRow?
What is the datatype of rowid?