can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
Answer Posted / arun ashok
Select max(salary) from employee where salary not in (select
max(salary) from employee)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is bulkcopy in sql?
What is the stored procedure?
What is bookmark link in ssrs?
How can you tell if a database object is invalid?
Explain log shipping?
What is the significance of master, tempdb and model databases?
What is normalization of database? What are its benefits?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
What is an execution plan?
How to recreate an existing index in ms sql server?
Define indexes?
What are views used for?
What is database black box testing?
What is the difference between DataRow.Delete() and DataRow.Remove()?
How to create a Master database in SQL server ?