SQL select
| From: | Jiří Němec | Date: | Mon, 21 Jul 2003 10:07:31 +0000 |
| Subject: | SQL select | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-156033@lists.php.net to get a copy of this message | ||
heloo,
i have got a MySQL table:
id_comp id_goods type
cooler aa1256 n
cooler aa1255 n
cooler aa1317 f
cooler aa1196 n
cpu cpu183 n
cpu cpu177 f
cpu cpu190 n
gk gk1265 f
gk gk1258 n
gk NULL i
gk gk1193 n
gk gk1257 n
mb mb1111 f
ram mem713 n
ram me1112 f
ram mem704 n
ram me1081 n
and I need only first row of each component order by type. so:
cooler aa1317 f
cpu cpu177 f
gk NULL i
mb mb1111 f
ram me1112 f
has somebody some idea hot to select?
jiří němec, ICQ: 114651500
www.menea.cz - www stránky a aplikace