select bumen from table where nl = (select distinct max(nl) from from table)
passionke(每一步都改变未来,却只能有一种结局!)select bumen from table where nl = (select distinct max(nl) from table) . andyli001(我的程序我做主) 你的不对,要修改一下: select bumen from table as t1 where t1.nl+1>(select max(t2.nl) from table as t2)
.
andyli001(我的程序我做主)
你的不对,要修改一下:
select bumen from table as t1 where t1.nl+1>(select max(t2.nl) from table as t2)