sql = "select userorder,insertdate from insert_tab where insertdate between fromdate and todate"
这个是选择在表insert_tab中处于日期fromdate和todate之间的所有纪录。我现在要实现查找出这些记录中(userorder是自然序列,和insertdate是同向增长)的某一位(假设为n)的纪录。我该怎么办呢?
userorder为整数
...全文
20513打赏收藏
送分的问题。不会的,不回复的,打pp
sql = "select userorder,insertdate from insert_tab where insertdate between fromdate and todate" 这个是选择在表insert_tab中处于日期fromdate和todate之间的所有纪录。我现在要实现查找出这些记录中(userorder是自然序列,和insertdate是同向增长)的某一位(假设为n)的纪录。我该怎么办呢? userorder为整数
sql = "select userorder,useraccount,insertdate from (select userorder,useraccount,to_char(insertdate,'yyyy/mm/dd') insertdate from insert_tab where rownum=insertorder insertdate between to_date('"+fromdate+"','yyyy-mm-dd') and to_date('"+todate+"','yyyy-mm-dd')) where rownum < (insertorder+1)
minus
select userorder,useraccount,insertdate from (select userorder,useraccount,to_char(insertdate,'yyyy/mm/dd') insertdate from insert_tab where rownum=insertorder insertdate between to_date('"+fromdate+"','yyyy-mm-dd') and to_date('"+todate+"','yyyy-mm-dd')) where rownum < insertorder
";
sql = "select userorder,insertdate from insert_tab where userorder=(select min(userorder) from insert_tab where (insertdate between fromdate and todate))+3"