Interested to Buy Any Domain ? << Click Here >> for more details...
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
What are the possible values that can be stored in a boolean data field?
What are the different types of joins in sql?
how to use regular expression in pattern match conditions? : Sql dba
How is debugging done?
Does inner join return duplicate rows?
Which data type is a composite type?
What is difference between sql function and stored procedure?
What is the difference between cluster and non-cluster index?
How does sql*loader handles newline characters in a record? : aql loader
Which type of cursor is used to execute the dml statement?
Explian rowid, rownum? What are the psoducolumns we have?
How long does it take to learn pl sql?
What is the usage of sql functions?
What is sql procedures and functions?
What is a unique key?
