Re: Breaking down a table field....

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



yep, sure is.....
SELECT DISTINCT(Unit), Count(Unit) from TABLE  GROUP BY Unit

hth
jd


                                                                                                                                           
                      Tristan.Pretty@risk.                                                                                                 
                      sungard.com                 To:       jeffrey_n_Dyke@Keane.com                                                       
                                                  cc:       php-db@lists.php.net                                                           
                      08/07/2003 09:52 AM         Subject:  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 the
unit?

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.
***********************************************************************







-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux