求一条查询语句 根据时间排序后create_date desc 当ID=？ 时的 rownum序号
select rownum from tablename where id=? order by create_date desc
是这样吧，还是我理解错了
SELECT * FROM 表名 ORDER BY create_date DESC WHERE id='rownum序号';
select rownum from tablename where id=? 和后面的排序没有关系
SELECT A.ROWNUM,A.ID FROM (SELECT * FROM TABLE ORDER BY create_date desc) AS A WHERE A.ID = ?
select rownum,t.* from
(select* from tablename a order by create_date desc ) t where id =?
我感觉永远是1。。。
select * from (select rownum paixu,t.* from
(select* from tablename a order by create_date desc) t) where seq_no =12
刚才没测试 这样就行了
rownum 是根据查询的结果后排序的
ROWNUM是一种伪列，它会根据返回记录生成一个序列化的数字。
select * from (
select rownum rn,t.id from
(select a.id from tablename a order by create_date desc) t
) t2
where t2.id =12;
select rn
from (select rownum as rn from tablename order by create_date desc)
这样试试