I am beginner in SQL Server, I want to write the following query in T-SQL, and I can’t find out how to do it
SELECT 
    SUM(PROSPECTS), 
    MARQUE,
    LANGUAGE 
FROM
    USERS 
CASE Marque IN (0, 16, 30, 36) THEN Group BY MARQUE ELSE Group By Language
Can someone help me please?
Advertisement
Answer
Close…
group by CASE Marque IN (0, 16, 30, 36) THEN MARQUE ELSE Language END
But also need to apply same context at the top
SELECT 
    SUM(PROSPECTS), 
    CASE Marque IN (0, 16, 30, 36) THEN MARQUE ELSE Language END MarqLang
FROM
    USERS 
group by
   CASE Marque IN (0, 16, 30, 36) THEN MARQUE ELSE Language END