find out the third highest salary?
Answer Posted / mahesh
select * from emp where sal<(select max(sal) from emp
where sal<(select max(sal) from emp))
Is This Answer Correct ? | 11 Yes | 10 No |
Post New Answer View All Answers
How do I use os authentication with weblogic jdriver for oracle and connection pools?
Why use resource manager in Oracle?
What are the arithmetic operations?
How to run create database statement again?
What is an oracle database table?
Explain the use of record option in exp command.
How to drop an existing view in oracle?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How to update values on multiple rows in oracle?
How to use null as conditions in oracle?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
Give the various exception types.
What is the difference between post-database commit and post-form commit?
Explain a data segment?