SELECT PROD,MAX(DATE) AS newDATE FROM TABELNAME GROUP BY PROD
select prod,max([date]) as Max_Date from table group by prod
SELECT * FROM TABLENAME A WHERE DATE = (SELECT MAX(DATE) FROM TABLENAME B WHERE A.PROD = B.PROD)
select prod,max([date]) as Max_Date from table group by prod
select prod,max(date) as MaxDate from table group by prod
select prod,max(date) as MaxDate from table group by prod
select (select max([date]) from table where prod=a.prod) as number ,* from table as a
select prod,max(date) as maxDate from table group by prod
select prod,max(data) as maxdata from table1 group by prod
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]
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 行)
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 行)