how to find the second highest salary from emp table?
Answer Posted / kishor dange
select max(sal) from table_name where sal<(select max(sal)
from table_name)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is user in sql?
What is pivot in sql?
What is a constraint? Tell me about its various levels.
what is recursive stored procedure? : Sql dba
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
how many columns can be used for creating index? : Sql dba
How run sql*plus commands that are stored in a local file?
What is meant by temporal data?
What is the difference between microsoft sql and mysql?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
What is graph sql?
What are the different operators available in sql?
Write a query to find the names of users that begin with "um" in sql?
What are the triggers associated with image items?
When should I use nosql database?