Answer Posted / chandra sekhar
SELECT * FROM EMP e
where 3=(select count(*) from emp
where e.sal<=sal)
Using this correlated subquery we can easily get any one
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can we insert in sql function?
How can I tell if sql is running?
what is a stored procedure? : Sql dba
Explain what is a view?
What will you get by the cursor attribute sql%notfound?
How to run sql statements with oracle sql developer?
Explain polymorphism in pl/sql.
What are the usages of sql?
Define commit, rollback and savepoint?
What is the difference between the conventional and direct path loads? : aql loader
What is latest version of sql?
What is pl sql in dbms?
Is sql a scripting language?
What is tuple in sql?
How many aggregate functions are available there in sql?
