瀹炲垪鏁版嵁搴? - 鐧惧害鏂囧簱

鏂板缓

涓婁紶

棣栭〉

鍔╂墜

鏈�杩?/div>

璧勬枡搴?/div>

宸ュ叿

 

 

瀹為獙

4 

 

鏁版嵁搴撶殑鏌ヨ�㈠拰璇曞�?/p>

 

T4.1 

 

鏁版嵁搴撶殑鏌ヨ��

 

锛?/p>

1

锛?/p>

 

SELECT 

璇�鍙ョ殑鍩烘湰浣跨�?/p>

 

 

 

1.

瀵逛簬瀹為獙

2

缁欏嚭鐨勬暟鎹�搴撹〃缁撴瀯锛屾煡璇㈡瘡涓�闆囧憳鐨勬墍鏈夋暟鎹?/p>

 

 

銆愭�濊�冧笌缁冧範銆戠敤

SELECT 

璇�鍙ユ煡璇�

Departments

鍜?/p>

Salary

琛ㄤ腑鎵�鏈夌殑鏁版嵁淇℃伅

 

 

2.

鐢?/p>

SELECT

璇�鍙ユ煡璇�

Employees

琛ㄤ腑姣忎釜闆囧憳鐨勫湴鍧�鍜岀數璇?/p>

 

 

銆愭�濊�冧笌缁冧範銆?/p>

a.

鐢?/p>

SELECT

璇�鍙ユ煡璇�

Departments

鍜?/p>

salary

琛ㄤ腑鐨勪竴鍒楁垨鑻ュ共鍒?/p>