how to calcuate the second highest salary of he employee
- 13 Answers
- 16617 Views
- Synechron, I also Faced
- E-Mail Answers
Answer Posted / lalit
select name, sal from (select name,sal from emp where sal<(select max(sal) from emp) order by sal desc)where rownum=1;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can a table contain multiple primary key’s?
what is a stored procedure? : Sql dba
how can we repair a mysql table? : Sql dba
Is pl sql a programming language?
What is full form of rtm?
what is collation? : Sql dba
how many triggers are allowed in mysql table? : Sql dba
What is a scalar value in sql?
what are null values? : Sql dba
Is null operator in sql?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
How to prepare for oracle pl sql certification?
Why do we use subquery?
How do I run a script in sql developer?
Is ms sql is free?
