鏁版嵁搴揹istinct鐨勭敤娉曟湁鍝簺
扬州沐宇科技
2023-08-30 12:02:39
鏁版嵁搴撲腑鐨凞ISTINCT鍏抽敭瀛楃敤浜庤繑鍥炴寚瀹氬垪鐨勫敮涓€鍊笺€備互涓嬫槸DISTINCT鐨勪竴浜涘父瑙佺敤娉曪細
- SELECT DISTINCT column_name FROM table_name;
杩欏皢杩斿洖鎸囧畾鍒椾腑鐨勫敮涓€鍊硷紝鍘婚櫎閲嶅鐨勮銆?/p>
- SELECT column_name1, column_name2, 鈥?FROM table_name
WHERE condition
GROUP BY column_name1, column_name2, 鈥?/p>
杩欏皢杩斿洖绗﹀悎鏉′欢鐨勫敮涓€缁勫悎锛屾寜鐓ф寚瀹氱殑鍒楀垎缁勩€?/p>
- SELECT DISTINCT column_name1, column_name2, 鈥?FROM table_name
WHERE condition
杩欏皢杩斿洖绗﹀悎鏉′欢鐨勫敮涓€缁勫悎锛屽幓闄ら噸澶嶇殑琛屻€?/p>
- SELECT DISTINCT ON (column_name) column_name1, column_name2, 鈥?FROM table_name
ORDER BY column_name;
杩欐槸PostgreSQL鐗规湁鐨勮娉曪紝瀹冨皢鎸夌収鎸囧畾鐨勫垪杩涜鎺掑簭锛屽苟杩斿洖姣忎釜鍞竴鍊肩殑绗竴琛屻€?/p>
闇€瑕佹敞鎰忕殑鏄紝DISTINCT鍏抽敭瀛椾粎浣滅敤浜嶴ELECT璇彞涓殑鍒楋紝瀵逛簬鏁翠釜琛岃€岃█锛屾槸涓嶈捣浣滅敤鐨勩€?/p>
