select b.id,b.name
FROM (select id,nz(id,999('999')) as kk,name from a) as b order by b.kk asc
...全文
28回复打赏收藏
一个简单的排序问题的最终答案
to lyq111 假设表为 学号(id) 姓名(name) 002 l 003 m 004 p u t 008 g 问题:能不能把没有学号的记录排到最后去 数据库:Access 最终答案: select b.id,b.name FROM (select id,nz(id,999('999')) as kk,name from a) as b order by b.kk asc