... There wouldn't be any overhead since the DB isn't querying anything to get the value of [a].
...
Except the fact that this will lead to full table (or, if you have an index on this column, then Index) scan...
The syntax itself is valid as it can be executed just fine.