mysql> select * from shop;
+---------+--------+-------+
| article | dealer | price |
+---------+--------+-------+
|    0001 | A      |  3.45 | 
|    0001 | B      |  3.99 | 
|    0002 | A      | 10.99 |  
|    0003 | B      |  1.45 |  
|    0003 | C      |  1.69 | 
|    0003 | D      |  1.25 |  
|    0004 | D      | 19.95 | 
+---------+--------+-------+
7 rows in set (0.00 sec)