How to use an SQL reserved keyword like the column name "desc" in a select statement?
select "desc" from tablename
How to use an SQL reserved keyword like the column name "desc" in a select statement?
select "desc" from tablename
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;
back quotes worked for me in Hive SQL: I have a column named from, so:
select `from` from myTable;