Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / swapnil tikale
Select top 1 salary from (select distinct top 2 salary from employee order by salary desc) as sal order by salary ;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can I call a procedure inside a function?
What are the different dml commands in sql?
What is trigger in pl sql?
What is thread join () in threading?
Can you load data into multiple tables at once? : aql loader
What is the difference between left join and right join?
Can unique keys be null?
Why do we use function in pl sql?
What is a table partition?
Can we call procedure in select statement?
What are joins in sql?
what are tables and fields? : Sql dba
how many ways to get the current time? : Sql dba
how is exception handling handled in mysql? : Sql dba
Enlist the characteristics of pl/sql?