how to check the 3rd max salary from an employee table?
Answer Posted / akilis.org@hotmail.com
Let us Assume
Table Name=salary
Column Name=maxsal
select * from salary order by maxsal desc limit 2,1;
Enjoy the simple code :)
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How to handle bulk data?
What are synonyms in sql?
what are the differences between binary and varbinary? : Sql dba
How bulk collect improves performance?
What is record variable?
What are expressions?
what is a database? : Sql dba
What is trigger and types?
What is inner join in sql?
How do I view a view in sql?
What is a stored procedure in sql with example?
how to include character strings in sql statements? : Sql dba
How do I write a sql query in pgadmin 4?
How do you define a foreign key?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?