一个SQL语句，急！

[bpaibgy]

在一表中，有字段prod，date,同一个prod值，对应有很多个data,写一个selsct语句，把不同的prod中对应的最大的data值的记录取出来，该怎么写，请指教！

[CrazyFor]

select prod,max([date]) as Max_Date from table group by prod

[dapper]

SELECT PROD,MAX(DATE) AS newDATE FROM TABELNAME GROUP BY PROD

[blactte]

select prod,max([date]) as Max_Date from table group by prod

[ttyp]

SELECT * FROM TABLENAME A WHERE DATE = (SELECT MAX(DATE) FROM TABLENAME B WHERE A.PROD = B.PROD)

[cbzdream]

select prod,max([date]) as Max_Date from table group by prod

[飞天林]

select prod,max(date) as MaxDate from table group by prod

[cappuccinomn]

select prod,max(date) as MaxDate from table group by prod

[xiajianfeng]

select (select max([date]) from table where prod=a.prod) as number ,* from table as a

[fyg_02971]

select prod,max(date) as maxDate from table group by prod

[kinny_ke]

up

[shengjun791031]

select prod,max(data) as maxdata from table1 group by prod

[Michael2003]

select *, a.[data] as maxdata from table as a where a.[data]=(select max(b.[data]) from table as b where a.[prod]=b.[proc] group by b.[prod]

[benxie]

create table a (a varchar(10),b int)

insert into a values ('a',1)
insert into a values ('a',2)
insert into a values ('a',3)
insert into a values ('b',1)
insert into a values ('b',2)
insert into a values ('b',3)

select a,max(b) from a group by a
a b
---------- -----------
a 3
b 3

（所影响的行数为 2 行）