simple query to view matching record and count
From: <cricketunes_at_yahoo.com>
Date: Tue, 2 Mar 2010 17:23:38 -0800 (PST)
Message-ID: <4e67b349-1ea7-4788-a785-2c62bf12a113_at_e7g2000yqf.googlegroups.com>
I have the following table
Date: Tue, 2 Mar 2010 17:23:38 -0800 (PST)
Message-ID: <4e67b349-1ea7-4788-a785-2c62bf12a113_at_e7g2000yqf.googlegroups.com>
I have the following table
Student:marks
Steve:90
Sam:85
Sue:95
Mark:75
Steve:100
Mark:81
Sue:92
Sue:94
What query would provide me a list of all students with names beginning with S and the number of records they are present in?
i.e
Steve 2
Sam 1
Sue 3
Thanks,
C
Received on Tue Mar 02 2010 - 19:23:38 CST