how to find the second highest salary from emp table?
Answer Posted / syed hussain
select min(salary) from tbl_emp where salary in
(select top 4 salary from Tbl_emp order by salary desc)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can you view the errors encountered in a trigger?
How many types of cursors are available in pl/sql?
Why truncate is faster than delete?
What is indexing oracle sql?
What is delimiter in pl sql?
What is trigger in sql?
Why is the cursor important?
How do you bind variables in pl sql?
What is the difference between explicit and implicit cursors in oracle?
Are stored procedures faster than queries?
What are all different types of collation sensitivity?
Do we need commit after truncate?
what is user defined functions? : Sql dba
How do I sort a table in sql?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba