Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- +--------------+------------------+------+-----+---------+----------------+
- | Field | Type | Null | Key | Default | Extra |
- +--------------+------------------+------+-----+---------+----------------+
- | id | int(11) | NO | PRI | NULL | auto_increment |
- | id_categoria | int(10) unsigned | NO | | NULL | |
- | nome | varchar(32) | NO | | NULL | |
- | qnt_vendida | int(10) unsigned | YES | | 0 | |
- +--------------+------------------+------+-----+---------+----------------+
- SET sql_mode='';
- SELECT id_categoria, nome FROM produtos GROUP BY id_categoria;
- SELECT id_categoria, ANY_VALUE(nome) FROM produtos GROUP BY id_categoria;
Add Comment
Please, Sign In to add comment