SELECT * FROM [dbo].[Vote_gjgfbsbdjls] a left join (select c.zxmc,c.xmmc,max(c.bc) as maxbc from [dbo].[Vote_gjgfbsbdjls] c group by c.zxmc,c.xmmc) b on a.zxmc=b.zxmc and a.xmmc=b.xmmc and a.bc=b.maxbc WHERE a.zxmc='${p}' ${if(len(flag)==0,"","and 1=2")} and b.maxbc is not null 该sql如何写分页sql（无排序字段） |
1min目标场景问卷
立即参与
最佳回答 |
||||
|
0
|
|
|||
