CODEWITHSUNDEEP
sql-servergroup-by
amit
amit

Reputation: 1

SQL Server exception on column name

When i have a column say "GROUP"

TableName.GROUP

during select it show me error 

Incorrect syntax near the keyword 'GROUP'

I tried 

  select [TableName.GROUP] from TableName

it shows me invalid column name TableName.GROUP

i tried

select [dbo.TableName.GROUP] from TableName

i received the same error invalid column name dbo.TableName.GROUP

I need the column name "GROUP". How to fix it?

Upvotes: 0

Views: 2032

Answers (1)

a1ex07
a1ex07

Reputation: 37364

 select [TableName].[GROUP] from TableName
 // or
 select [GROUP] from TableName

Upvotes: 6

Related Questions