Discussion :: Introduction to SQL - General Questions (Q.No.13)
A subquery in an SQL SELECT statement is enclosed in:
Answer: Option C
No answer description available for this question.
|Ankur said: (Nov 26, 2010)|
|select <column_name> from <table_name> where <column_name>=(select
<column_name> from <table_name2);
|Yash Nahar said: (Sep 29, 2014)|
|Could you please explain it in more detail?|
|Santosh Pakhare said: (Aug 9, 2015)|
|Sub-query always enclosed in parenthesis i.e ( ).|
|Pritam Gupta said: (Nov 19, 2015)|
|select * from emp where emp_id=123 AND (emp_name='abc ' OR emp_add='xyz');|
|Etenduk Jackson said: (Nov 20, 2016)|
|You are correct @Pritam.
Subquery are statement enclose () for pre-definition.
Post your comments here:
Email : (optional)
» Your comments will be displayed only after manual approval.