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 the difference between indexing and hashing?
Explain the stored procedure?
What structure can you implement for the database to speed up table reads?
What is use of except clause? How it differs from not in clause?
If a table does not have a unique index, can a cursor be opened on it?
Explain different types of lock modes in sql server 2000?
Explain the properties of sub-query in sql server?
What are examples of triggers?
How to create a ddl trigger using "create trigger" statements?
How do you delete a trigger?
How to receive output values from stored procedures?
What are database states in ms sql server?
How do I create a partition table in sql server?
What is a collation?
If we delete pack Spec what will be the status of pack Body ?