--如何在SQL中過濾某一列的重復值并返回顯示所有的數據,兩方法:
--方法一（推薦）
SELECT * FROM (SELECT *,(ROW_NUMBER() over( partition by CARD_ID order by DATE_ENTERED )) as gropuby FROM dbo.ER_CARD) d WHERE d.gropuby=1
--方法二，ＩＤ需要是整型
select * from ER_CARD where id in (select MIN(id),CARD_ID from ER_CARD group by CARD_ID);
