Is group by 1 a standard SQL?

Viewed 46

Is group by 1 a standard SQL?

The SQL like this:

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

This SQL is right in MySQL. But I want to know that can it work in SQL server or Oracle? I do not have SQL server or oracle service, please help me.

0 Answers
Related