This is neither supportet in SQL Server, nor Oracle. Also what is the advantage of doing this?

you can simply write:

select c_name, count(1) as number from table_one group by c_name

Much more readable, and if your select ever gets changed your Group By still works like a charm.