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
How do you delete a table?
How can use stored procedures in sql?
What is a data definition language?
Where is all the data on the internet stored?
How do you declare a constant?
What is right join in sql?
What are hotfixes and patches?
Enlist some predefined exceptions?
What is form and report?
what is collation? : Sql dba
What is dynamic sql in pl sql?
what is the difference between group by and order by in sql? : Sql dba
Describe different types of general function used in sql?
Why partition by is used in sql?
What is difference between stored procedures and application procedures?