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
Is pl sql and postgresql same?
how to convert character strings to dates? : Sql dba
Does sql profiler affect performance?
What is delete command in sql?
What are database links used for?
How to Declare Fixed Length String Value In PL SQL
what are set operators in sql? : Sql dba
What is the use of sqldataadapter?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What are the benefits of pl sql?
What are sql triggers used for?
What is sql key?
What is difference between nchar and nvarchar?
what is the difference between delete and truncate statement in sql? : Sql dba
how would you get the current date in mysql? : Sql dba