假设编号列为SNSELECT TOP(1) COUNT(1) AS cntFROM [表名]WHERE [SN] LIKE '001%'GROUP BY LEN([SN])ORDER BY LEN([SN]) DESC
