1818
1818
(2,1), (1,3), (2,1), (4,4), (2,2), (1,4);
1820
1820
SELECT a FROM t1 ORDER BY (SELECT c FROM t2 WHERE b > 2 );
1822
1822
SELECT a FROM t1 ORDER BY (SELECT c FROM t2 WHERE b > 1);
1823
1823
SELECT a FROM t1 ORDER BY (SELECT c FROM t2 WHERE b > 2), a;
1825
1825
SELECT a FROM t1 ORDER BY (SELECT c FROM t2 WHERE b > 1), a;
1827
1827
SELECT b, MAX(c) FROM t2 GROUP BY b, (SELECT c FROM t2 WHERE b > 2);
1829
1829
SELECT b, MAX(c) FROM t2 GROUP BY b, (SELECT c FROM t2 WHERE b > 1);
1832
1832
SELECT a FROM t1 GROUP BY a
1833
1833
HAVING IFNULL((SELECT b FROM t2 WHERE b > 2),
1834
1834
(SELECT c FROM t2 WHERE c=a AND b > 2 ORDER BY b)) > 3;
1836
1836
SELECT a FROM t1 GROUP BY a
1837
1837
HAVING IFNULL((SELECT b FROM t2 WHERE b > 1),
1838
1838
(SELECT c FROM t2 WHERE c=a AND b > 2 ORDER BY b)) > 3;