如果这个表就两个字段 select distinct date,unit into newtable from 一个表truncate table 一个表insert 一个表 select * from newtabledrop table newtable
zjcxc(邹建) 有 灌分 嫌疑,哈哈~
试了不行,我把整个贴出来了select distinct a.[dateid], a.[unitid],b.[title],b.[categoryid] from AccessLog a inner join CmsUnits b on a.unitid=b.unitid order by a.[dateid] desc,a.[time] desc,b.categoryid
楼主: select distinct * from 表名,不可能不行的啊;你是不是想将过滤后的结果存回表去的?另外,我建议你改名为:who am i.(说笑而已!^_^)
select distinct a.[dateid], a.[unitid],b.[title],b.[categoryid] from AccessLog a inner join CmsUnits b on a.unitid=b.unitid order by a.[dateid] desc,a.[time] desc,b.categoryid-->select a.[dateid], a.[unitid],b.[title],b.[categoryid] from ( select distinct [unitid],b.[title],max([time]) as [time] from AccessLog ) as a inner join CmsUnits b on a.unitid=b.unitid order by a.[dateid] desc,a.[time] desc,b.categoryid
错了,更正:select distinct a.[dateid], a.[unitid],b.[title],b.[categoryid] from AccessLog a inner join CmsUnits b on a.unitid=b.unitid order by a.[dateid] desc,a.[time] desc,b.categoryid-->select a.[dateid], a.[unitid],b.[title],b.[categoryid] from ( select [dateid],[unitid],max([time]) as [time] from AccessLog group by [dateid],[unitid] ) as a inner join CmsUnits b on a.unitid=b.unitid order by a.[dateid] desc,a.[time] desc,b.categoryid
select distinct date, unit from mytab
select distinct date,unit
into newtable
from 一个表truncate table 一个表insert 一个表
select * from newtabledrop table newtable
select distinct * from 表名,不可能不行的啊;你是不是想将过滤后的结果存回表去的?另外,我建议你改名为:who am i.(说笑而已!^_^)
select distinct [unitid],b.[title],max([time]) as [time] from AccessLog
) as a inner join CmsUnits b
on a.unitid=b.unitid
order by a.[dateid] desc,a.[time] desc,b.categoryid
select [dateid],[unitid],max([time]) as [time] from AccessLog
group by [dateid],[unitid]
) as a inner join CmsUnits b
on a.unitid=b.unitid
order by a.[dateid] desc,a.[time] desc,b.categoryid