how to find the second highest salary from emp table?
Answer Posted / hemanth kumar
select salary from employees where rowid=(select rowid from
employees where rownum<=2
minus
select rowid from employees where rownum<2)
order by salary
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is difference between inner join and self join?
Is microsoft sql free?
What are % type and % rowtype?
What is bitemporal narrowing?
What are different functions in sql?
How do you add a column to a table?
Can we use pl sql in sql server?
What are transaction and its controls?
How can you tell the difference between an index and a view?
what is bcp? When does it used? : Sql dba
What is the difference between a query and a report?
Which normal form is best?
What is use of term?
What are local and global Indexes and where they are useful.
what is the difference between truncate and delete statement? : Transact sql