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 create table inside stored procedure?
What is the basic structure of an sql?
what is the difference between clustered and non clustered index in sql? : Sql dba
What is the difference between the sql*loader and import utilities? : aql loader
What is difference between hql and native sql?
Can a composite key be null?
Enlist the advantages of sql.
What is dml with example?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
How does a covering index work?
What is indexing oracle sql?
What is the use of function in sql?
what is an alias command? : Sql dba
what is a primary key? : Sql dba
How many types of triggers are there in pl sql?
