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 are the two characteristics of a primary key?
How many tables can a sql database have?
What is clustered index in sql?
What is mutating sql table?
What is indexing oracle sql?
What is the starting oracle error number? What is meant by forward declaration in functions?
How do you identify a primary key?
How to sort the rows in sql.
Is sql port 1433 encrypted?
Can %notfound return null after a fetch?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What are the packages in pl sql?
What is cursor in pl sql?
What is memory optimized?
What is tuple in sql?