SQL DISTINCT
鍙戝竷: 2008-12-05 14:05 | 浣滆: 缃戠粶杞浇 | 鏉ユ簮: 缃戠粶杞浇 | 鏌ョ湅: 13娆
select distinct(c1),count(c1)
from table1
group by c1;
濡傛灉鎯冲緱鍒帮紝閲嶅鏁版嵁璁板綍鏁板ぇ浜100鐨勯噸澶嶅唴瀹瑰拰鏁伴噺鐨勬柟寮忔槸锛
select distinct(c1),count(c1)
from table1
group by c1
having count(c1) 銆100;
;




鍙戝竷: 2008-12-05 14:05 | 浣滆: 缃戠粶杞浇 | 鏉ユ簮: 缃戠粶杞浇 | 鏌ョ湅: 13娆