Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / varun
select sal from emp where rownum=2 order by sal desc;
Is This Answer Correct ? | 6 Yes | 19 No |
Post New Answer View All Answers
What is anonymous block in sql?
How many types of cursors supported in pl/sql?
How to write a query to show the details of a student from students table whose
What is difference between inner join and self join?
What is dba in sql? : SQL DBA
What is trigger point?
What is lookup table in sql?
Why do we use joins in sql?
How do you remove duplicate records from a table?
How to call shell script from pl sql procedure?
Write the command to remove all players named sachin from the players table.
What are the types of join in sql?
How does cross join work?
What is bind variable in pl sql?
difference between anonymous blocks and sub-programs.