SQL Select Distinct with multiple columns

Question

I have the following select statement which works fine (using SQL Server 2012) :

SELECT distinct(Department) FROM Projects

But when I try the following:

SELECT 'January', distinct(Department) FROM Projects

I get an error message that I could not understand what was next to (

I tried the group by as well but did not seem to work:

SELECT 'January' mm, distinct(Department)
FROM Projects
GROUP BY mm

But what are you trying to do? What is your expected output? — Mosty Mostacho
– Mosty Mostacho, Commented Dec 8, 2013 at 3:03

LHA · Accepted Answer · 2013-12-08 02:53:47Z

1

Try this:

SELECT DISTINCT department, 'January' mm FROM projects

One note: You should uppercase SQL keywords.

answered Dec 8, 2013 at 2:53

LHA

9,7158 gold badges56 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Yes; DISTINCT is not a function, so no parentheses.