how to find the second highest salary from emp table?
Answer Posted / velmurugan p
Select min(sal) from table_name where sal in(Select top 2 sal from table_name)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is cursor explain with example?
Is left join same as join?
What is varray in pl sql?
What can sql server reporting services do?
Define commit?
How can you get sql*loader to commit only at the end of the load file? : aql loader
What is the difference between inner join and outer join?
How delete all records from table in sql?
What is scalar and vector?
What is the difference between alter trigger and drop trigger statements?
What is loop in pl sql?
What are the steps for performance tuning.
How do you remove duplicate records from a table?
What is difference between ms sql and mysql?
What are the different types of functions in sql?