How do I use '#' to be a column name in SQL

Question

I want to declare a table which has a column name 'A#'

but # is the comment notation in sql,

I have tried 'A#' , '[A#]' ,but it's still not work.

Is it available to use # in column name?

Answer 1

try the following

select `A#` from table;