how to find the second highest salary from emp table?
Answer Posted / sabari
select max(salary ) from emp where salary<(select max
(salary)from emp )
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is sql exception?
what is data manipulation language? : Sql dba
What is the difference between jpql and sql?
Difference between table function and pipelined function?
what is sql in mysql? : Sql dba
What are the benefits of triggers?
Why do we use view in sql?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
How do you write a complex sql query?
Is merge a dml statement?
What is the difference between the conventional and direct path loader? : aql loader
Which constraints we can use while creating database in sql?
Is sql pronounced sequel or sql?
What is sql integrity?
What is pl/sql language case sensitive?