Database - Introduction to SQL - Discussion

Discussion :: Introduction to SQL - General Questions (Q.No.13)

13. 

A subquery in an SQL SELECT statement is enclosed in:

[A]. braces -- {...}.
[B]. CAPITAL LETTERS.
[C]. parenthesis -- (...) .
[D]. brackets -- [...].

Answer: Option C

Explanation:

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:

Name *:

Email   : (optional)

» Your comments will be displayed only after manual approval.