how to access columns if they are named after numbers

162 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 best solutions below

1
On

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

0
On
select "0" from table