Database - Introduction to SQL - Discussion
Discussion Forum : 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.
Discussion:
4 comments Page 1 of 1.
Shital said:
5 years ago
@Amir Explained very well.
Jojo said:
6 years ago
Well said @Amir.
Amir said:
7 years ago
@Bhavika is correct.
Example:
SELECT * FROM table1 WHERE (col1, col2) = (SELECT col3, col4 FROM table2 WHERE id = 10);
Example:
SELECT * FROM table1 WHERE (col1, col2) = (SELECT col3, col4 FROM table2 WHERE id = 10);
Bhavika said:
1 decade ago
This is false because it does not use square braces
it uses ()
it uses ()
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers