how to access columns if they are named after numbers

147 views Asked by At

My column names in my table are just numbers from 0-20, where each column is corresponding to a number however, when I try

    select 0 from table

I get output of only zeroes in my column, how can I select a column without changing the column names?

2

There are 2 answers

1
Johnny Fitz On

Try select [0] from table. Your way is replicating zeros for all entries in the table

0
Matthew Jackson On
select "0" from table