SELECT Unit,COUNT(Unit) as quantity FROM TABLE GROUP BY Unit -- Oscar Satorre Pérez [usban@eresmas.com] -- ----- Mensaje Original ----- Remitente: Tristan.Pretty@risk.sungard.com Destinatario: jeffrey_n_Dyke@Keane.com Fecha: Jueves, Agosto 7, 2003 3:52pm Asunto: Re: Breaking down a table field.... >Next question.... >How can I show how many of each there were? >SO now I have > >breafast >lunch >dinner > >I want to have > >breafast 2 >lunch 3 >dinner 3 > >etc... >is that just as easy? > > > > > > > >jeffrey_n_Dyke@Keane.com >07/08/2003 14:42 > > > To: Tristan.Pretty@risk.sungard.com > cc: php-db@lists.php.net > Subject: Re: Breaking down a table field.... > > > >SELECT DISTINCT(Unit) from TABLE_NAME; > > > > > > Tristan.Pretty@risk. > sungard.com To: php- >db@lists.php.net > > cc: > 08/07/2003 09:37 AM Subject: >Breaking down a table field.... > > > > > > >I have a table, wth many entries. >Each entry has been asigned a unit to belong to. > >I want to list all the units dynamically. >How can I display all the units, without displaying each instance of >theunit? > >EG: > >Unit item >breakfast cereal >breakfast toast >lunch salad >lunch sandwich >dinner steak >dinner pie >lunch soup >dinner lasagne > >and so on.. >I'd wanna get a list of: >breafast >lunch >dinner > >not several instances of each... >how can I do this? > >********************************************************************* >The information contained in this e-mail message is intended only for >the personal and confidential use of the recipient(s) named above. >If the reader of this message is not the intended recipient or an agent >responsible for delivering it to the intended recipient, you are hereby >notified that you have received this document in error and that any >review, dissemination, distribution, or copying of this message is >strictly prohibited. If you have received this communication in error, >please notify us immediately by e-mail, and delete the original >message.*************************************************************** ******** > > > > > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php > > > > > >********************************************************************* >The information contained in this e-mail message is intended only >for >the personal and confidential use of the recipient(s) named above. >If the reader of this message is not the intended recipient or an agent >responsible for delivering it to the intended recipient, you are >hereby >notified that you have received this document in error and that any >review, dissemination, distribution, or copying of this message is >strictly prohibited. If you have received this communication in >error, >please notify us immediately by e-mail, and delete the original >message.*************************************************************** ******** > ></SPAN> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
