Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / akshay
Select ename, eno, sal, rownum
from (select ename, eno, sal from emp order by sal desc)
where rownum = 2;
Is This Answer Correct ? | 7 Yes | 7 No |
Post New Answer View All Answers
Explain normalization and what are the advantages of it?
What is a common use of group by in sql?
What is pl sql commands?
What is left join in sql?
Why do we use function in pl sql?
Is sql sequential or random?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What is secondary key?
What is an escape character in sql?
What is nvl?
How much does a sql dba make? : SQL DBA
What is the max nvarchar size?
What are variables in pl sql?
How can use stored procedures in sql?
How do I run sql?