Database - Introduction to SQL - Discussion

Discussion :: Introduction to SQL - True or False (Q.No.5)

5. 

A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.

[A]. True
[B]. False

Answer: Option B

Explanation:

No answer description available for this question.

Bhavika said: (Sep 29, 2011)  
This is false because it does not use square braces
it uses ()

Amir said: (Sep 8, 2016)  
@Bhavika is correct.

Example:

SELECT * FROM table1 WHERE (col1, col2) = (SELECT col3, col4 FROM table2 WHERE id = 10);

Jojo said: (Dec 3, 2016)  
Well said @Amir.

Shital said: (Nov 11, 2017)  
@Amir Explained very well.

Post your comments here:

Name *:

Email   : (optional)

» Your comments will be displayed only after manual approval.