Answer Posted / swastik
SELECT LEVEL, MAX(Sal)
FROM Emp
GROUP BY LEVEL
HAVING LEVEL = &GiveNo
CONNECT BY PRIOR Sal > Sal;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you explain an index number?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
what is timestamp in mysql? : Sql dba
what is 'mysqld'? : Sql dba
What is java sql driver?
What is data modelling in sql?
Is sql harder than python?
what is rollback? : Sql dba
what is auto increment? : Sql dba
Name the operator which is used in the query for pattern matching?
How is a PL/SQL code compiled?
What trigger means?
what is the difference between undefined value and null value? : Sql dba
Explain the rollback statement?
what are properties of a transaction? : Sql dba