SELECT SGH, LEFT(SGH, CASE WHEN charindex('-', sgh) > 0 THEN charindex('-', sgh) - 1 ELSE len(sgh) END) AS bb FROM cpgsljk GROUP BY LEFT(SGH, CASE WHEN charindex('-', sgh) > 0 THEN charindex('-', sgh) - 1 ELSE len(sgh) END) --把计算公式作为组就行了
不要写别名,写完整 SELECT SGH, LEFT(SGH, CASE WHEN charindex('-', sgh) > 0 THEN charindex('-', sgh) - 1 ELSE len(sgh) END) AS bb FROM cpgsljk GROUP BY LEFT(SGH, CASE WHEN charindex('-', sgh) > 0 THEN charindex('-', sgh) - 1 ELSE len(sgh) END)
- 1 ELSE len(sgh) END) AS bb
FROM cpgsljk
GROUP BY
LEFT(SGH, CASE WHEN charindex('-', sgh) > 0 THEN charindex('-', sgh)
- 1 ELSE len(sgh) END)
--把计算公式作为组就行了
SELECT SGH, LEFT(SGH, CASE WHEN charindex('-', sgh) > 0 THEN charindex('-', sgh)
- 1 ELSE len(sgh) END) AS bb
FROM cpgsljk
GROUP BY LEFT(SGH, CASE WHEN charindex('-', sgh) > 0 THEN charindex('-', sgh)
- 1 ELSE len(sgh) END)