计算carton_no 的数量

[happy3677]

怎样写SQL 可以计算carton_no 的数量？

select key_part_no,mac_id,serial_number,carton_no,version_code from SFISm4.r107
where ship_no='VPK6080035'
order by carton_no



KEY_PART_NO MAC_ID SERIAL_NUMBER CARTON_NO VERSION_CODE
1 FWM883513002J 0016B6FB6108 JME006801035 J0608K2004 16
2 FWM883513002J 0016B6FB60EC JME006800956 J0608K2004 16
3 FWM883513002J 0016B6FB5E76 JME006800807 J0608K2004 16
4 FWM883513002J 0016B6FB5F6E JME006800827 J0608K2004 16
5 FWM883513002J 0016B6FB5FA2 JME006800808 J0608K2004 16
6 FWM883513002J 0016B6FB5B1E JME006800546 J0608K2004 16
7 FWM883513002J 0016B6FB5A76 JME006800471 J0608K2004 16
8 FWM883513002J 0016B6FB59CE JME006800548 J0608K2004 16
9 FWM883513002J 0016B6FB5A9A JME006800434 J0608K2004 16
10 FWM883513002J 0016B6FB5BA6 JME006800096 J0608K2004 16
11 FWM883513002J 0016B6FB6192 JME006800322 J0608K2005 16
12 FWM883513002J 0016B6FB5ADE JME006800237 J0608K2005 16
13 FWM883513002J 0016B6FB5BC0 JME006800249 J0608K2005 16
14 FWM883513002J 0016B6FB5ACA JME006800244 J0608K2005 16
15 FWM883513002J 0016B6FB5B08 JME006800217 J0608K2005 16
16 FWM883513002J 0016B6FB6148 JME006800950 J0608K2005 16
17 FWM883513002J 0016B6FB5A7A JME006800474 J0608K2005 16
18 FWM883513002J 0016B6FB5A9E JME006800488 J0608K2005 16
19 FWM883513002J 0016B6FB6130 JME006800683 J0608K2005 16
20 FWM883513002J 0016B6FB5BD2 JME006801106 J0608K2005 16

[AFIC]

select count(distinct carton_no) from SFISm4.r107
where ship_no='VPK6080035'

[xuexizherole]

认同楼上地