At 02:33 PM 4/23/01 -0700, elias wrote:
>how can i get an SQL statment that when run, i get a query result like that:
>
>Id: Value count:
>--- --------------
>a 4 values
>b 4 values
>c 2 values
SELECT ID,COUNT(*) FROM table_name GROUP BY ID;
>i feel that it's easy...but i'm not really good at SQL.
..and you probably won't get better at it here. Try an SQL list or any
number of online tutorials or books on SQL.
- Brian
-------------------------------------
Brian S. Dunworth
Sr. Software Development Engineer
Oracle Database Administrator
The Printing House, Ltd.
(850) 875-1500 x225
<[EMAIL PROTECTED]>
-------------------------------------
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
