可否用一条sql语句实现？

Question

我的表结构：
+--------------+---------+------+-----+---------+----------------+
| Field        | Type    | Null | Key | Default | Extra          |
+--------------+---------+------+-----+---------+----------------+
| symbol       | char(8) | YES  |     | NULL    |                |
| date         | date    | YES  |     | NULL    |                |
| open         | double  | YES  |     | NULL    |                |
| high         | double  | YES  |     | NULL    |                |
| low          | double  | YES  |     | NULL    |                |
| close        | double  | YES  |     | NULL    |                |
| vol          | double  | YES  |     | NULL    |                |
| adj          | double  | YES  |     | NULL    |                |
| id           | int(10) | YES  |     | NULL    |                |
| new_field_id | int(10) | NO   | PRI | NULL    | auto_increment |
+--------------+---------+------+-----+---------+----------------+
select symbol, min(close) from quote  where symbol='YHOO';
+--------+------------+
| symbol | min(close) |
+--------+------------+
| YHOO   |       8.11 |
+--------+------------+
select symbol, min(close) from quote  where  symbol='AACC';
+--------+------------+
| symbol | min(close) |
+--------+------------+
| AACC   |       3.29 |
+--------+------------+
我想得到下面的结果，可否用一条语句完成，
+--------+------------+
| symbol | min(close) |
+--------+------------+
| YHOO   |       8.11 |
+--------+------------+
| AACC   |       3.29 |
+--------+------------+

Answer 1

select symbol, min(close) from quote where symbol in ('AACC','YHOO') group by symbol

Answer 2

select symbol, min(close) from quote  where symbol='YHOO' or symbol='AACC' group by symbol;

Answer 3

还有一种 
select symbol, min(close) from quote where symbol='YHOO' 
union all
select symbol, min(close) from quote where symbol='AACC';