我只想要前七个
sql("MESRPT_P1WR01","select * from (select distinct histdate from SDB_TB_EQP_HIST order by histdate desc) where rownum < 8 ",1)
limit top ROWNUM
参考：https://blog.csdn.net/qq_43371004/article/details/88807862
要看数据库的
mysql 是 select*from 表 limit 7
sqlsever 是select top 7 * from 表
orcle 是select * from 表 where rownum<8
1min目标场景问卷
立即参与
