Answer Posted / ram
select * from emp
where sal in(select max(sal) from emp
where level=&nth
connect by prior sal>sal
group by level)order by sal
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is normalization sql?
Explain constraints in sql?
What's the difference between inner join and left join?
How many types of tables are there?
What is the use of %rowtype?
What is composite data type in pl sql?
What are triggers in sql?
Why partition by is used in sql?
How to run pl sql program in mysql?
how can we find the number of rows in a table using mysql? : Sql dba
List the different type of joins?
What is the difference between join and natural join?
What are the syntax and use of the coalesce function?
How do you declare a user-defined exception?
Why primary key is required?
