获取第一条数据

admin

错误方法

1. SELECT * FROM tableName where fd_rt = 'A'
   
2. and rownum=1
   
3. ORDER BY fd_date DESC
   

复制代码

正确使用方式为：

1. SELECT t.* from
   
2. (
   
3. SELECT * FROM tableName where fd_rt = 'A' ORDER BY fd_date DESC
   
4. ) t WHERE rownum = 1
   

复制代码