can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
Answer Posted / kumar_kisna
select max(salary) from table where salary<(select max
(salary) from table)
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How to use order by with union operators in ms sql server?
What is the difference between DataRow.Delete() and DataRow.Remove()?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
What is difference between clustered and non clustered index?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What are the types of subquery?
when would you go for denormalization? : Sql server database administration
How to choose all records from the table?
What is wide table?
What is normalization of database?
What is a transactions?
What are diverse clauses that form a part of sql?
How will you find out if there are expensive SQL statements running or not?
What is sql language?
Explain about remote stored procedure?