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
- 31716 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
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
How many types of schemas are there?
What are the advantages of having an index on the sql server?
What are the export options of ssrs?
what is the different types of backups available in sql server? : Sql server database administration
What is the purpose of forms?
Which table keeps information about stored procedures?
How to use subqueries with the in operators in ms sql server?
What are the different acid properties?
List out the differences between the clustered index and non-clustered index in sql server?
Why should one not prefix user stored procedures with ‘sp_’?
How do I edit a stored procedure in sql server?
how to do partition in sqlserver
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
