how to find the second highest salary from emp table?
Answer Posted / surendra sharma
select min(sal) from table_name where sal in
(SELECT top 2 sal FROM table_name order by sal desc)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a subquery and a join?
what is 'mysqlcheck'? : Sql dba
What is case function?
What is substitution variable?
What are character functions?
explain the difference between delete , truncate and drop commands? : Sql dba
How do I find sql profiler?
Can we use pl sql in sql server?
What is t sql used for?
What is a sql schema used for?
What is primary key and foreign key?
what are the types of subquery? : Sql dba
what is a composite key ? : Sql dba
What is Difference Between Unique and Primary Key Constraints?
Determine if oracle date is on a weekend?