sql问题
select * from EnrollInfo where id like '19500101% ' and number=(select max(number) from EnrollInfo)
数据：
number id
1 195001010001
2 195001010002
3 195001010003
4 195001010004
5 195001010005
6 195001010006
7 195001010007
8 195001010008
9 195001010009
10 195001010010
11 195001010011
前面查询都没有问题！但是到了查找12就不行了！为什么？？
[解决办法]
select * from EnrollInfo where number=(select max(number) from EnrollInfo where id like '19500101% ')
