Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / reddy
select distinct (a.sal) from emp a where &n = (select count
(distinct(b.sal) from emp bmwhere a.sal<=b.sal)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How does an execution block start and end in pl sql?
What is the usage of nvl function?
What is the use of count (*) in sql?
What is the current version of postgresql?
How many unique keys can a table have?
What is the reports view in oracle sql developer?
Is record in oracle pl sql?
What is the difference between in and between in sql?
Can we create clustered index without primary key?
What is the difference between having clause and where clause?
Can we rename a column in the output of sql query?
What are different types of triggers?
What are different types of keys?
What is the use of pl/sql table?
What are sql*plus environment variables?