大佬们,按条件筛选的情况下,如果想要实现不输入查询条件的时候默认搜出来前10行数据展示,该怎么写,以下是我的语句: select * from dbo.salesIssue si left join dbo.checkAndAccept caa on si.fineId=caa.FineId left join dbo.invoicing inv on inv.fineId=caa.FineId left join dbo.makeCollections mc on mc.fineId=inv.fineId where 1=1 ${if(len(text_productCode)==0,"","AND si.productCode ='"+text_productCode+"'")} ${if(len(text_documentNo)==0,"","AND si.documentNo ='"+text_documentNo+"'")} ${if(len(text_purchaserUnit)==0,"","AND si.purchaserUnit ='"+text_purchaserUnit+"'")} ${if(len(text_orderNo)==0,"","AND si.orderNo ='"+text_orderNo+"'")} ; |