Groups With SQL

Is there a way with SQL to query certain groups from the same table?That would help me later to display the results in few columns(HTML table).

Example:

1st column- product ID (unique)
2nd column - product name
3rd column - group (here we have values that repeat themselves like:cans, meat, beverages, etc.)

All I want is to query by groups with SQL so the recordset would consist of: cans, meat and beverages (columns). Than I would list the products in every separate column. I don't know if this could be done? I know how to query one group of them only, but I need that for every group I have.

example;
sql = "SELECT * FROM table WHERE group='cans', "