[請問] Access的distinct該怎麼寫?:－2016 台北日本料理推薦 , 台北日本料理吃到飽 , 台北日本料理名店 , 台北日本料理吃到飽推薦 , 台北日本料理推薦2014

Blogtrottr

批踢踢實業坊 ask 板

Jul 19th 2013, 18:31, by rockon

作者rockon ()

站內ask

標題[請問] Access的distinct該怎麼寫?

時間Fri Jul 19 18:31:08 2013

突然被交辦要用Access把重覆的資料去除掉但沒寫SQL語法已經三年多了 Access更是十年前碰的，所以....求救!! 欄位名稱: EXPORTER_BAN (需distinct) 其他欄位名：DECL_NO, SEND_DATE, DECL_TYPE, EXPORTER_NAME_E, EXPORTER_ADDRESS_E 請問我語法該怎麼寫，才可以輸出成所有欄位，但是EXPORTER_BAN是distinct的謝謝高手了!! -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 202.173.43.207

This entry passed through the Full-Text RSS service — if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers. Five Filters recommends: 'You Say What You Like, Because They Like What You Say' - http://www.medialens.org/index.php/alerts/alert-archive/alerts-2013/731-you-say-what-you-like-because-they-like-what-you-say.html

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions