写一个sql,表tab1字段A、B、C,C为创建时间,B为数字型,找到B在100到1000之间,创建时间最大的记录我自己的弄的答案:Select * from(select rownum,A,B,C FROM tab1 where B between 100 and 1000 order by C) rownum =1;现不知道这句是不是正确的,请高手指教,谢谢
调试欢乐多
or
select * from (
select rownum,A,B,C FROM tab1 where B between 100 and 1000 order by C) a
order by b desc limit 1
from tb1 T1
where T1.B between 100 and 1000
order by C desc
limit 1
FROM
tab1
WHERE b BETWEEN 100 AND 1000
ORDER BY c DESC LIMIT 1;