Discussion :: Introduction to SQL - True or False (Q.No.5)
A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.
Answer: Option B
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.
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:
Email : (optional)
» Your comments will be displayed only after manual approval.