what is a sub query?how will you calculate working days in
a month using sub query?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define a temp table?

551


Can we insert in sql function?

538


How do I delete a trigger?

541


What is oracle and pl sql?

659


What is prepared statement in sql?

543






What are the types of functions in sql?

567


What is the difference between sql and mysql?

551


What do you mean by rowid?

538


What is asqueryable?

529


what is column? : Sql dba

568


Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

546


which types of join is used in sql widely? : Sql dba

537


how to delete an existing column in a table? : Sql dba

550


what are the differences among rownum, rank and dense_rank? : Sql dba

536


What are analytic functions in sql?

547