[Scottish] sql

Tam McLaughlin scottish at mailman.lug.org.uk
Tue Jan 28 15:17:08 2003

i am trying something in mysql but can't remember any sql.
Say i have a field called name in table 1 and i want to select the
name and the number of times that name appears in the table,
how would i do it?
If u can tell me, i can find the equiv syntax in mysql
Tam McLaughlin
IT Systems Administrator
Scottish Legal Life Assurance Society Ltd