/SQL/Sql group by different columns

Sql group by different columns

How to select two columns from table with group by one sql server

SELECT Name, Size, AVG( UnitPrice )
   FROM Products
   GROUP BY Name, Size;

2

Source: dcx.sybase.com

Similar codes

2 votes173 views2 answers
How to create an empty table from an existing table
SQL
0 vote183 views1 answer
Sql with example
SQL
12 votes197 views4 answers
Mysql version query
SQL
0 vote219 views2 answers
What is rownum in oracle
SQL
0 vote193 views1 answer
What is metadata in sql
SQL
2 votes278 views1 answer
Brew start postgres manual
SQL
2 votes254 views1 answer
How to check grants on a package in oracle
SQL
1 vote189 views1 answer
Oracle sql assign unique number to each grouping
SQL
0 vote181 views1 answer
Alter boolean column postgresql
SQL
0 vote184 views1 answer
Like sql for second letter of the family name
SQL

Share