怎样去除重复行?

[Carlroy]

下面的查询有重复行...如何去除呢.......
"Select Car_Time.Car_time_ID as 车次,Car_Time.Car_Number as 车号,Car_Time.Car_Name_ID as 编号,Car_Time.Car_Name 车型 from Car_Time,Settlement where Car_Time.Car_time_id not in(select settlement.car_time_id from settlement) order by car_time.Car_time_ID"

[dotnba]

1、distinct
2、group

[dahaidao]

对！

[llzczf]

delete Car_Time
where rowid<>
select max(rowid)
from Car_Time
where Car_Time.Car_time_ID =(
"Select Car_Time.Car_time_ID
from Car_Time
where Car_Time.Car_time_id not
in(select settlement.car_time_id from settlement)
order by car_time.Car_time_ID"))
利用他们的ROWID是唯一的。这样可以保留多条中的要和条

[ccat]

select distinct * into ... from ...
delete ...
insert ... select * from ...