how to calcuate the second highest salary of he employee
Answer Posted / shailesh
select sal from emp where sal=(select max(sal) from emp
where sal<(select max(sal) from emp);
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
explain the difference between bool, tinyint and bit. : Sql dba
What is cost in sql execution plan?
How do I write a cron which will run a sql query and mail the results to agroup?
How to sort the rows in sql.
What can you do with pl sql?
How do you create a unique index?
what is subquery? : Sql dba
how to drop an existing view in mysql? : Sql dba
What is mutating trigger?
What is difference between ms sql and mysql?
What is compiled query?
Can we use rowid as primary key?
What is an emotional trigger?
Can function return multiple values in sql?
What is scalar function in sql?