how to find the second highest salary from emp table?
Answer Posted / rameshwari
select ename,esal from
(select ename,esal from hsal
order by esal desc)
where rownum <=2;
| Is This Answer Correct ? | 123 Yes | 242 No |
Post New Answer View All Answers
What is the difference between rename and alias?
What are actual parameters and formal parameters?
What is the difference between a primary key and a clustered index?
What normalization means?
What is nvarchar max in sql?
Is it important to partition hard disk?
Which version of sql do I have?
what is csv? : Sql dba
What is keys and its types?
How do I save a sql query?
What is rtm in testing?
How to add new employee details in an employee_details table with the following details
What is pl sql quora?
What is group function in sql?
What is an exception in pl/sql?