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
what is the difference between undefined value and null value? : Sql dba
What is acid property in a database?
Explain ttitle and btitle.
How do I view stored procedures?
What are joins in sql?
What are predefined functions in sql?
What is the difference between nvl function, ifnull function, and isnull function?
Is sql free?
how to calculate expressions with sql statements? : Sql dba
What is sql dialect?
How sql query is executed?
What is PL/SQL Records?
What happens when a trigger is associated to a view?
Which sorts rows in sql?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?