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 id <>
(select max(salary) from employee)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Define Joins?
What are the advantages of stored procedure in sql server?
How do I start sql server 2016?
Tell me what is normalization? Explain different forms of normalization?
How to get the definition of a trigger back?
What is trigger explain with program?
What are sql server procedures?
what is a live lock? : Sql server database administration
Explain the types of indexes.
What is schemabinding a view?
Is it possible to replicate data from sql server to oracle? : sql server replication
Distinguish between commit and rollback?
How do you size a resultset?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
do you know how to configure db2 side of the application? : Sql server database administration