Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / deepa
select min(salary) from (select salary from table_name order by salary desc) where rownum<3;
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How to handle bulk data?
How to get list of all tables from a database?
does sql support programming? : Sql dba
what is the command used to fetch first 5 characters of the string? : Sql dba
how to return query output in html format? : Sql dba
how to shut down the server with 'mysqladmin'? : Sql dba
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
Why do we use function in pl sql?
What are local and global variables and their differences?
How do I access sql anywhere database?
What is difference between ms sql and mysql?
what is the difference between $message and $$message? : Sql dba
how to analyze tables with 'mysqlcheck'? : Sql dba
Is sql between inclusive?
What is database sql?