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

How to add new employee details in an employee_details table with the following details

823


What are the different tcl commands in sql?

815


Does sql view stored data?

722


how to select first 5 records from a table? : Sql dba

693


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

742






When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

843


How can you select unique records from a table?

701


What is memory optimized table?

763


what is “go” in t-sql? : Transact sql

810


How do temporal tables work?

692


how many ways to get the current time? : Sql dba

708


which tcp/ip port does sql server run on? : Sql dba

706


What do you think about pl/sql?

701


Which one is faster ienumerable or iqueryable?

657


What are tables in sql?

738