Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 27 Answers
- 27159 Views
- I also Faced
- E-Mail Answers
Answer Posted / preetir
select min(sal) from (select distinct sal from emp order by
desc where rownum < 2)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is oracle pl sql developer?
What are the popular database management systems in the it industry?
What are the disadvantages of file system?
What is union, minus and interact commands?
What is a stored procedure in sql with example?
how to create a new view in mysql? : Sql dba
What are the three forms of normalization?
What are different types of functions in sql?
What is a heap in sql?
What is trigger explain with example?
what does the t-sql command ident_incr does? : Transact sql
Which is faster subquery or join?
What is the difference between instead of trigger and after trigger?
What steps server process has to take to execute an update statement?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
