4

How to use an SQL reserved keyword like the column name "desc" in a select statement?

select "desc" from tablename
LittleBobbyTables - Au Revoir
  • 32,008
  • 25
  • 109
  • 114
saun4frsh
  • 383
  • 1
  • 4
  • 21

3 Answers3

13

Use brackets

select [desc] from tablename
juergen d
  • 201,996
  • 37
  • 293
  • 362
0

According to Standard, you can use delimited identifiers in this case, ex.

create table Tdesc("desc" int);
go
select "desc" from Tdesc order by "desc" desc;
msi77
  • 1,602
  • 1
  • 11
  • 10
0

back quotes worked for me in Hive SQL: I have a column named from, so:

select `from` from myTable;