Re: simple query to view matching record and count
From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 3 Mar 2010 06:14:00 +0100
Message-ID: <4b8df017$0$12223$426a74cc_at_news.free.fr>
Date: Wed, 3 Mar 2010 06:14:00 +0100
Message-ID: <4b8df017$0$12223$426a74cc_at_news.free.fr>
<cricketunes_at_yahoo.com> a écrit dans le message de news: 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
What about doing your homework yourself?
Regards
Michel
Received on Tue Mar 02 2010 - 23:14:00 CST