how to find the second highest salary from emp table?
Answer Posted / gurvinder
select max(sal)from emp where sal in(select sal from emp minus select max(sal) from emp);
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is sharding in sql?
Describe sql comments?
what is the difference between primary key and unique key? : Sql dba
Is mariadb nosql?
How do you update sql?
which tcp/ip port does sql server run on? : Sql dba
What is the difference between a subquery and a join?
How to call shell script from pl sql procedure?
Is grant a ddl statement?
What is the current version of sql?
How do I debug a stored procedure?
What is the difference between partition and index?
explain commit and rollback in mysql : sql dba
What are pl sql data types?
Is primary key an index?