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
- 11875 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
How do I edit a trigger in sql developer?
What is view? Can we update view
What are the two parts of design view?
How to display Row Number with Records in Oracle SQL Plus?
How to run sql statements through the web interface?
What is asqueryable?
What's the procedure?
how to convert character strings to dates? : Sql dba
What are the ways on commenting in a pl/sql code?
how does a local variable is defined using t-sql? : Transact sql
what is bdb (berkeleydb)? : Sql dba
How to avoid using cursors?
What is a constraint? Tell me about its various levels.
What is java sql driver?
What is composite primary key in sql?
