Interested to Buy Any Domain ? << Click Here >> for more details...
can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 31691 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
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
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
Does server sql treat char as a variable-length or fixed-length column?
What does truncate do?
What are click through reports?
What is implicit cursors?
Why are sql functions used?
Explain full-text indexing?
What is the most common type of join?
What is unpivot?
How to list all triggers in the database with sys.triggers in ms sql server?
What does the on delete cascade option do?
What is the simplest way to create a new database in ms sql server?
What are the purpose of Normalisation?
what is checksum in sql server.........???
What is extended stored procedures?
