how to check the 3rd max salary from an employee table?
Answer Posted / kotesh
select level,max(salary) from employee
where level=3
connect by prior salary>salary
group by level;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is sql server agent? : Sql dba
Are pl sql variables case sensitive?
How long it takes to learn pl sql?
How do I quit sql?
What is a sql instance vs database?
What is difference between stored function and application function?
Is oracle sql free?
how to fetch alternate records from a table? : Sql dba
What are the types of views in sql?
What is sql stand for?
What is t sql in sql server?
How do I create a memory optimized filegroup?
How can we store rows in PL/SQL using array?
What is the execution plan in sql?
How does a self join work?