Interested to Buy Any Domain ? << Click Here >> for more details...
what is a sub query?how will you calculate working days in
a month using sub query?
- 4 Answers
- 12050 Views
- InteQ, I also Faced
- E-Mail Answers
Answer Posted / ankur akash
A query inside a query is a sub query.
The first query depends for its execution based on the
result provided by the execution of inside query. i.e. subquery.
For ex.
Select last_name, salary, job_id
from employees
where salary >(select last_name, salary
from employees
where last_name = 'Higgins');
Here
Select last_name, salary, job_id
from employees
where salary >
talks about the first query depending for its result based
on the execution of the inner query i.e. sub query
(select last_name, salary
from employees
where last_name = 'Higgins');
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is nosql db?
What is break?
what is oracle database ? : Sql dba
What are the benefits of stored procedures?
What does pl sql developer do?
What is full form of rtm?
What are the ways on commenting in a pl/sql code?
What is difference between pls_integer and integer?
what is sql in mysql? : Sql dba
What is the difference between rename and alias?
What are the most important characteristics of pl/sql?
What is primary key sql?
What are the uses of sysdate and user keywords?
Can there be 2 primary keys in a table?
When to use inner join and left join?
