can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
Answer Posted / harikumar
select max(salary) as secondMax from employee where salary
<> (select max(salary) from employee)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is primary key index?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
How real and float literal values are rounded?
What is the library index called?
How does recursive cte works in sql server?
What are the recovery models for a database?
What is the default sql server instance name?
How to send email from database?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How to assign new column names in a view?
what is the maximum size of a row? : Sql server database administration
Explain partitioned view?
What is local temp table?
When I delete any data from a table, does the sql server reduce the size of that table?
How to provide column names in insert statements in ms sql server?