SELECT TOP 16 id, pm, dwmc, rq, sj, gg, jg, wzdm, lb FROM dbo.gqxxmx WHERE (id IN (SELECT MAX(id) FROM gqxxmx WHERE xxlb = 2 AND (wzdm LIKE 'A1101' OR wzdm LIKE 'A1102' OR wzdm LIKE 'A1103' OR wzdm LIKE 'A1104' OR wzdm LIKE 'A2101' OR wzdm LIKE 'A2102' OR wzdm LIKE 'A2104' OR wzdm LIKE 'A2105' OR wzdm LIKE 'A2106' OR wzdm LIKE 'A2109' OR wzdm LIKE 'A2107' OR wzdm LIKE 'A3101' OR wzdm LIKE 'A3105' OR wzdm LIKE 'A3102' OR wzdm LIKE 'A3202' OR wzdm LIKE 'A3103' OR wzdm LIKE 'A3203' OR wzdm LIKE 'A3201' OR wzdm LIKE 'A3104' OR wzdm LIKE 'A3204' OR wzdm LIKE 'A4101' OR wzdm LIKE 'A4201' OR wzdm LIKE 'A4301' OR wzdm LIKE 'A4401' OR wzdm LIKE 'A4405' OR wzdm LIKE 'A5102' OR wzdm LIKE 'A5103' OR wzdm LIKE 'A5104' OR wzdm LIKE 'B2101' OR wzdm LIKE 'B2112' OR wzdm LIKE 'B2102' OR wzdm LIKE 'B2103' OR wzdm LIKE 'B2104' OR wzdm LIKE 'B2105' OR wzdm LIKE 'B2113' OR wzdm LIKE 'B2108' OR wzdm LIKE 'B2109' OR wzdm LIKE 'B2110' OR wzdm LIKE 'B1101' OR wzdm LIKE 'B3102' OR wzdm LIKE 'B31024' OR wzdm LIKE 'B3106' OR wzdm LIKE 'B3107' OR wzdm LIKE 'B3109' OR wzdm LIKE 'B31023' OR wzdm LIKE 'B31020' OR wzdm LIKE 'B3205' OR wzdm LIKE 'B31021' OR wzdm LIKE 'B3206' OR wzdm LIKE 'B3209' OR wzdm LIKE 'C4101' OR wzdm LIKE 'C4102' OR wzdm LIKE 'C3101' OR wzdm LIKE 'C3102' OR wzdm LIKE 'C3201' OR wzdm LIKE 'C3202' OR wzdm LIKE 'C3203' OR wzdm LIKE 'C3204' OR wzdm LIKE 'C3106' OR wzdm LIKE 'C3107' OR wzdm LIKE 'C3108' OR wzdm LIKE 'D3101' OR wzdm LIKE 'D3102' OR wzdm LIKE 'D4101' OR wzdm LIKE 'D2103' OR wzdm LIKE 'D2102' OR wzdm LIKE 'D1101' OR wzdm LIKE 'D1102' OR wzdm LIKE 'G03' OR wzdm LIKE 'G02' OR wzdm LIKE 'G01' OR wzdm LIKE 'A4409') AND wzdm <> '' AND lb IS NOT NULL GROUP BY dwmc)) ORDER BY rq DESC, sj DESC
不可能存在这种现象的.
FROM dbo.gqxxmx
WHERE (id IN
(SELECT MAX(id)
FROM gqxxmx
WHERE xxlb = 2 AND (wzdm LIKE 'A1101' OR
wzdm LIKE 'A1102' OR
wzdm LIKE 'A1103' OR
wzdm LIKE 'A1104' OR
wzdm LIKE 'A2101' OR
wzdm LIKE 'A2102' OR
wzdm LIKE 'A2104' OR
wzdm LIKE 'A2105' OR
wzdm LIKE 'A2106' OR
wzdm LIKE 'A2109' OR
wzdm LIKE 'A2107' OR
wzdm LIKE 'A3101' OR
wzdm LIKE 'A3105' OR
wzdm LIKE 'A3102' OR
wzdm LIKE 'A3202' OR
wzdm LIKE 'A3103' OR
wzdm LIKE 'A3203' OR
wzdm LIKE 'A3201' OR
wzdm LIKE 'A3104' OR
wzdm LIKE 'A3204' OR
wzdm LIKE 'A4101' OR
wzdm LIKE 'A4201' OR
wzdm LIKE 'A4301' OR
wzdm LIKE 'A4401' OR
wzdm LIKE 'A4405' OR
wzdm LIKE 'A5102' OR
wzdm LIKE 'A5103' OR
wzdm LIKE 'A5104' OR
wzdm LIKE 'B2101' OR
wzdm LIKE 'B2112' OR
wzdm LIKE 'B2102' OR
wzdm LIKE 'B2103' OR
wzdm LIKE 'B2104' OR
wzdm LIKE 'B2105' OR
wzdm LIKE 'B2113' OR
wzdm LIKE 'B2108' OR
wzdm LIKE 'B2109' OR
wzdm LIKE 'B2110' OR
wzdm LIKE 'B1101' OR
wzdm LIKE 'B3102' OR
wzdm LIKE 'B31024' OR
wzdm LIKE 'B3106' OR
wzdm LIKE 'B3107' OR
wzdm LIKE 'B3109' OR
wzdm LIKE 'B31023' OR
wzdm LIKE 'B31020' OR
wzdm LIKE 'B3205' OR
wzdm LIKE 'B31021' OR
wzdm LIKE 'B3206' OR
wzdm LIKE 'B3209' OR
wzdm LIKE 'C4101' OR
wzdm LIKE 'C4102' OR
wzdm LIKE 'C3101' OR
wzdm LIKE 'C3102' OR
wzdm LIKE 'C3201' OR
wzdm LIKE 'C3202' OR
wzdm LIKE 'C3203' OR
wzdm LIKE 'C3204' OR
wzdm LIKE 'C3106' OR
wzdm LIKE 'C3107' OR
wzdm LIKE 'C3108' OR
wzdm LIKE 'D3101' OR
wzdm LIKE 'D3102' OR
wzdm LIKE 'D4101' OR
wzdm LIKE 'D2103' OR
wzdm LIKE 'D2102' OR
wzdm LIKE 'D1101' OR
wzdm LIKE 'D1102' OR
wzdm LIKE 'G03' OR
wzdm LIKE 'G02' OR
wzdm LIKE 'G01' OR
wzdm LIKE 'A4409') AND wzdm <> '' AND lb IS NOT NULL
GROUP BY dwmc))
ORDER BY rq DESC, sj DESC