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 sql trigger example?
What are functions in sql?
What are all ddl commands?
What is the difference between numeric and autonumber?
Why do we use partitions in sql?
Do ddl statements need commit?
What are conditional predicates?
explain what is mysql? : Sql dba
What is cte?
How you improve the performance of sql*loader? : aql loader
can a stored procedure call itself or recursive stored procedure? : Sql dba
What is sql stand for?
Can you load data into multiple tables at once? : aql loader
What are the steps for performance tuning.
what are the differences between char and varchar? : Sql dba