Can Mysql 5.6 Do Sub Queries?

1.	Can Mysql 5.6 Do Sub Queries?
Answer» Yes ,A subquery is a SELECT statement within another statement. All subquery forms and operations that the SQL STANDARD requires are SUPPORTED, as WELL as a few features that are MySQL-specific. Here is an example of a subquery: SELECT * FROM T1 WHERE column1 = (SELECT column1 FROM t2); Yes ,A subquery is a SELECT statement within another statement. All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. Here is an example of a subquery: SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2);

Answer»

Yes ,A subquery is a SELECT statement within another statement.

All subquery forms and operations that the SQL STANDARD requires are SUPPORTED, as WELL as a few features that are MySQL-specific.

Here is an example of a subquery:

SELECT * FROM T1 WHERE column1 = (SELECT column1 FROM t2);

Yes ,A subquery is a SELECT statement within another statement.

All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific.

Here is an example of a subquery:

SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2);

Discussion