Home Forums SQL Server 7,2000 T-SQL select [Employee_ID] = EmpID from dbo.Employee GROUP BY [Employee_ID] RE: select [Employee_ID] = EmpID from dbo.Employee GROUP BY [Employee_ID]

  • February 20, 2008 at 7:42 am

    #780198

    Don't use the alias in the GROUP BY.

    You probably want:

    select EmpID as [Employee_ID] from dbo.Employee group by EmpID

    Or perhaps just simply use the DISTINCT, since you don't seem to be aggregating:

    select distinct EmpID as [Employee_ID] from dbo.Employee

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?