what is a sub query?how will you calculate working days in
a month using sub query?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / thiyagarajan
A subquery is a select statement within another select
statement.subquery is executed only once and the parent or
outer query will always depends on the value returned by it.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / mohana sundaram
to extract data from single table or multiple tables
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / p.rajasekar
ex
1)Method
Table tab1 data like Followings
Month date1 Working
Jan 1 0
Jan 1 1
Jan 1 1
Jan 1 0
.
.
.
Then the query should be
select Month,count(Working) from monthname m where working=1
group by Month,working
You will get answer 2;
2 Method
If we store the working days in same column
eg like(1=>Denotes Working,0=>denotes off)
Month Day1
Jan 101010101111
select Month,length(trim(replace(b.Day1,'0','')))
NoofWorkDays from workdays b
Please test it.Let me know the feed back
Is This Answer Correct ? | 1 Yes | 2 No |
What is the difference between left outer join and left join?
What is set transaction?
What is a REF CURSOR? Compare strong and week ref cursor types.
When the mutating error will comes? and how it will be resolved?
explain the delete statements in sql
What are character functions in sql?
What is rule base and cost base optimizer?
What is the difference between subquery and correlated query?
what are the type of locks ? : Sql dba
What is difference between cursor and trigger?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
how many values can the set function of mysql take? : Sql dba