取出一個表中某字段相同的數據
select top 339 * from Sheet where carNO in (select carNO from Sheet group by carNO having count(*)>1) order by carNO DESC
對比兩表中區分的數據并提出
select * from B where checksum(*) not in (select checksum(*) from A)
select * from kehu where checksum(車牌) not in (select checksum(車牌) from member) and checksum(客戶名稱)
表示是A表有,B表沒有的數據.