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
- 11719 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
Is sql workbench free?
what is the difference between cluster and non cluster index? : Sql dba
What is full form of rtm?
What are sql objects?
What are different types of indexes?
Can you sum a count in sql?
How do I filter in sql profiler?
What is the reports view in oracle sql developer?
Why coalesce is used in sql?
what are all the common sql function? : Sql dba
Does oracle roll back the transaction on an error?
Can we use having without group by in sql?
Which is faster view or stored procedure?
What is the difference between the implicit and explicit cursors?
What are the operators in sql?
