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
- 11709 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 not equal in sql?
What is the difference between left outer join and left join?
What are the types of variables use in pl sql?
what is 'mysqladmin' in mysql? : Sql dba
Can sql developer connect to db2?
Why do we need databases?
Is sql port 1433 encrypted?
Sql technical questions
What is sqlexception in java?
What is the difference between microsoft access and sql?
What is native sql query?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
what is a join? : Sql dba
What is the difference between inner join and natural join?
Is ms sql traffic encrypted?
