技术问答access select璇彞鎬庝箞浣跨敤 - 扬州沐宇科技

SELECT璇彞鐢ㄤ簬浠庢暟鎹簱涓€夋嫨鏁版嵁銆傚畠鐨勫熀鏈娉曞涓嬶細

SELECT 鍒楀悕1, 鍒楀悕2, ... FROM 琛ㄥ悕 WHERE 鏉′欢

鍏朵腑锛屽垪鍚嶆槸瑕侀€夋嫨鐨勬暟鎹垪锛屽彲浠ユ槸鍗曚釜鍒楁垨澶氫釜鍒楋紝鐢ㄩ€楀彿鍒嗛殧銆傝〃鍚嶆槸瑕佷粠涓€夋嫨鏁版嵁鐨勮〃鍚嶇О銆俉HERE瀛愬彞鍙€夛紝鐢ㄤ簬鎸囧畾閫夋嫨鏁版嵁鐨勬潯浠躲€?/p>

浠ヤ笅鏄竴浜涗娇鐢⊿ELECT璇彞鐨勭ず渚嬶細

SELECT * FROM 琛ㄥ悕;

SELECT 鍒楀悕1, 鍒楀悕2 FROM 琛ㄥ悕;

SELECT 鍒楀悕1, 鍒楀悕2 FROM 琛ㄥ悕 WHERE 鏉′欢;

鍦╓HERE瀛愬彞涓紝鍙互浣跨敤姣旇緝杩愮畻绗︼紙濡?銆?lt;>銆?lt;銆?gt;銆?lt;=銆?gt;=锛夈€侀€昏緫杩愮畻绗︼紙濡侫ND銆丱R銆丯OT锛夊拰閫氶厤绗︼紙濡?銆乢锛夋潵瀹氫箟鏉′欢銆?/p>

浠ヤ笂鏄疭ELECT璇彞鐨勫熀鏈敤娉曪紝杩樻湁鏇村楂樼骇鐢ㄦ硶锛堝浣跨敤鑱氬悎鍑芥暟銆佹帓搴忋€佸垎缁勭瓑锛夛紝鍙互鏍规嵁鍏蜂綋闇€姹傚湪SELECT璇彞涓坊鍔犵浉搴旂殑瀛愬彞銆?/p>