大佬们,按条件筛选的情况下,如果想要实现不输入查询条件的时候默认搜出来前10行数据展示,该怎么写,以下是我的语句:select * from dbo.salesIssue si left join dbo.checkAndAccept caa on si.fineId=caa.FineIdleft join dbo.invoicing inv on inv.fineId=caa.FineIdleft join dbo.makeCollections mc on mc.fineId=inv.fineIdwhere 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+"'")} ;