MariaDB [lyshark]> select num1 from tab1 where num1 > ANY(select num2 from tab2);
+------+
| num1 |
+...ALL实例: 返回tab2表中比tab2表num2列所有值都打的值,SQL语句如下:
MariaDB [lyshark]> select num1 from tab1 where num1 > ALL(...所有水果信息,使用UNION连接自动删除重复的行,查询结果,SQL语句如下:
MariaDB [lyshark]> select Gid,Name,Price from lyshark
-> where...表取别名o,查询30001订单的下单日期,SQL语句如下:
MariaDB [lyshark]> select * from orders AS o where o.o_num=30001;
+---...在前面还介绍了自连接查询,在连接两个表都是同一个表时,也可以使用别名机制,SQL语句如下:
MariaDB [lyshark]> select f1.Gid,f1.Name
-> from lyshark