Interested to Buy Any Domain ? << Click Here >> for more details...
how to check the 3rd max salary from an employee table?
- 23 Answers
- 37871 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / amit
select max(sal) from emp where sal<(select max(sal) from emp where sal<(select max(sal) from emp));
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is sql not null constraint?
Can we use loop in sql?
What is a temporal table?
What is keys and its types?
What is the difference between the conventional and direct path loads? : aql loader
What is primary key and foreign key?
What are the benefits of triggers?
How to Execute a Package in PL/SQL.?
How to select all records from the table?
What is difference between stored procedures and application procedures?
How to move files from one directory to another in pl sql?
What is the meaning of disabling a trigger?
List different type of expressions with the example.
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is pl sql block structure?
