what is a sub query?how will you calculate working days in
a month using sub query?
- 4 Answers
- 11061 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 to get list of all tables from a database?
How to revise and re-run the last sql command?
How do I find duplicates in the same column?
what is recursive stored procedure? : Sql dba
Explain lock escalation? : Transact sql
What is mutating trigger?
Write a sql select query that only returns each name only once from a table?
Are pl sql variables case sensitive?
Is pl sql useful?
What are the three forms of normalization?
How does cross join work in sql?
Explain the the update statement in sql?
What is data type in database?
What is the difference between having clause and where clause?
Where the sql database files are stored?
