SELECT BatchNumber,MAX(Id) FROM dbo.SceneryOrder
WHERE RowStatus=1 AND BatchNumber<>\'\' 
GROUP BY BatchNumber
ORDER BY 2 DESC

 

版权声明：本文为jiangqw原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/jaday/p/3506999.html