how to find the second highest salary from emp table?
Answer Posted / sumit sharma
select sal from (select distinct(sal) from emp where sal is
NOT NULL order by sal dsc) where rownum = 2
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is difference between hql and native sql?
How can I tell if sql is running?
how to create a test table in your mysql server? : Sql dba
Mention what is the plv (pl/vision) package offers?
How do you add a column to a table?
What are triggers and its types?
Why do we use joins?
what is data integrity? : Sql dba
What is varray in pl sql?
What are stored procedures in mysql?
what is msql? : Sql dba
What is index example?
What does varchar include?
Mention what does plv msg allows you to do?
What does desc stand for?