Group by clause

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

steveb. SSC-Forever Points: 46733 More actions · Answer 1

try using UNION

SELECT ClientId, ClientName, Versionsource

FROM YourTable

WHERE Versionsource = 'Manual'

Union

SELECT ClientId, ClientName, 'Auto' as Versionsource

FROM YourTable

WHERE Versionsource 'Manual'

allen davidson SSCertifiable Points: 7042 More actions · Answer 2

Or CASE

USE tempDB

GO

CREATE TABLE

X

(ClientIdINT,

ClientNameVARCHAR(50),

VersionsourceVARCHAR(50))

INSERT X

(ClientId,

ClientName,

Versionsource)

SELECT 1, 'X', 'David' UNION

SELECT 2, 'y', 'Manual' UNION

SELECT 3, 'Z', 'Richard' UNION

SELECT 4, 'A', 'Manual' UNION

SELECT 5, 'B', 'David'

SELECT

CASE

WHEN VersionSource = 'Manual' THEN 'Manual'

ELSE 'Auto'

END AS VersionSource,

COUNT(*) AS MyCount

FROM

X

GROUP BY

CASE

WHEN VersionSource = 'Manual' THEN 'Manual'

ELSE 'Auto'

END

Darpan Sarin SSC-Addicted Points: 421 More actions · Answer 3

Thanks Steve for ur quick response, but whether there is any way to do that work with Group by clause instead of Union?

Darpan Sarin SSC-Addicted Points: 421 More actions · Answer 4

Thanks a lot Allen that's the query i exactly wanted.

allen davidson SSCertifiable Points: 7042 More actions · Answer 5

No problem. CASE is hugely powerful and can be used in loads of places/problems.