[求助]access中sql语句求教

yellowjacky

有一个表table_a，有字段id,name,num，类型分别为文本，文本，数值
表中数据id,name都可重复，num唯一
现在我想取出id对应的name，同时num是最大的数据，请问select如何写？
谢谢

富戈

SELECT table_a.id, table_a.name, Max(table_a.num) AS num
FROM table_a
GROUP BY table_a.id, table_a.name
HAVING ((table_a.id)="111");

yellowjacky

QUOTE:

以下是引用富戈在2008-8-28 14:01:08的发言：
SELECT table_a.id, table_a.name, Max(table_a.num) AS num
FROM table_a
GROUP BY table_a.id, table_a.name
HAVING ((table_a.id)="111");

我想求出所有的id,不单单一条

7testing

SELECT *
FROM table_a
order by num desc

cheyoon

应用子查询：

SELECT table_a.id, table_a.name

FROM table_a

where table_a.num=(select max(table_a.num) from table_a)