select * from tb_baobiao_zhi t where txid='1320453632137112' and zdid in (select zdid from tb_baobiao_ziduan where bbid='132039155957416' and substr(zdmc,0,1)='0') order by zdid
查询出来的数据:
TXID ZDID ZHI
1320453632137112 132045351548195 1
1320453632137112 132045351548196 2
1320453632137112 132045351548197 3
1320453632137112 1320453515496100 6
1320453632137112 1320453515496102 7
1320453632137112 132045351549698 4
1320453632137112 132045351549699 5这个排序 错在哪里? ZDID1320453515496100和 1320453515496102 应该比其他的大 怎么回事?求解.......
查询出来的数据:
TXID ZDID ZHI
1320453632137112 132045351548195 1
1320453632137112 132045351548196 2
1320453632137112 132045351548197 3
1320453632137112 1320453515496100 6
1320453632137112 1320453515496102 7
1320453632137112 132045351549698 4
1320453632137112 132045351549699 5这个排序 错在哪里? ZDID1320453515496100和 1320453515496102 应该比其他的大 怎么回事?求解.......
order by to_number(ZDID)