菜鸟求一条语句，急！！！

Question

表table ID    Commdity_ID 
04    01 0401  02 0402  03 02    12 0201  21 0202  35 统计 前两位相同的  条数 也就是 统计 02和 04 开头的  条数ORACLE 数据库的

Answer 1

select substr(trim(id),1,2),count(*) from tablename
group by  substr(trim(id),1,2);

Answer 2

select substr(id,1,2),count(*)
from tablename 
group by  substr(id,1,2);

Answer 3

select substr(id,1,2),count(*)
from table
group by substr(id,1,2)

Answer 4

select substr(id,1,2),count(*)
from tb
group by  substr(id,1,2);

Answer 5

selecct substr(id, 1,2) title， count(count) ctn from test group by substr(id, 1,2)

Answer 6

select substr(id,1,2) id,count(*)
from t1 
group by substr(id,1,2)