Difference between sub query and nested query ?
Answer Posted / sravzzz
Sunbquery is a query within a query where as Nested query
is a subquery which resinde in the WHERE clause.
| Is This Answer Correct ? | 12 Yes | 15 No |
Post New Answer View All Answers
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
what are the default admin accounts in Oracle 10g ?
How to get maxsal , minsal, ename department wise in single query
What is the meaning of recursive hints in oracle?
How to rename an index in oracle?
How to update a table row with a record?
Explain what are synonyms used for?
What are the system predefined user roles?
Query to retrieve record for a many to many relationship ?
What are advantages of dateset in datastage?
What privilege is needed for a user to create views in oracle?
How can we find out the current date and time in oracle?
What is the difference between view and materialized view in Oracle?
What is oracle data type?
Why do we use bulk collect in oracle?