我要列出一个表中的最新10条数据中倒数7条,怎么写?
基本语句如下:
strsql="select * from(select source article_id,subject title,utime adddate,doc_type,title_color from newstitle where pub_status='1' and doc_type='1' order by utime desc) where rownum<11"
基本语句如下:
strsql="select * from(select source article_id,subject title,utime adddate,doc_type,title_color from newstitle where pub_status='1' and doc_type='1' order by utime desc) where rownum<11"
strsql= "select * from(select source article_id,subject title,utime adddate,doc_type,title_color from newstitle where pub_status= '1 ' and doc_type= '1 ' order by utime desc) where rownum <11"strsql= "select top 7 adddate * from (" & strsql &") order by adddate desc"