T
todaysoft
Unregistered / Unconfirmed
GUEST, unregistred user!
员工表T_Employee 取数据按员工编号排序时会显示
select * from T_Employee ORDER BY EmployeeNO
员工编号 姓名
A14 AAA
A140 BBB
A141 CCC
A15 DDD
A153 EEE
A17 FFF
A172 GGG
是否可以实现按这样排序显示:
员工编号 姓名
A14 AAA
A15 DDD
A17 FFF
A140 BBB
A141 CCC
A153 EEE
A172 GGG
select * from T_Employee ORDER BY EmployeeNO
员工编号 姓名
A14 AAA
A140 BBB
A141 CCC
A15 DDD
A153 EEE
A17 FFF
A172 GGG
是否可以实现按这样排序显示:
员工编号 姓名
A14 AAA
A15 DDD
A17 FFF
A140 BBB
A141 CCC
A153 EEE
A172 GGG