[Scottish] sql

Huard, Elise - D C&W Consultant scottish at mailman.lug.org.uk
Tue Jan 28 15:31:01 2003

select <name>, count(*) from <table> group by <name>;

	From:  Tam McLaughlin [SMTP:tamm@scotlegal.com]
	Sent:  28 January 2003 15:16
	To:  scottish@mailman.lug.org.uk
	Subject:  [Scottish] sql

	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

	Scottish mailing list
This email and any accompanying files are confidential.      If you are
not  the  intended recipient  you  must not use,  copy or disclose the
content.   If you have received this email in error please contact the 
sender by return email and delete this message. 
Thankyou for your co-operation.