Unanswered: Tricky query - listing alphabetically with freqency
I know this is a very tricky question but any recomended approaches would be much appretiated
Im using Oracle8i / SQL and have a table of members (table: Members), the column I'm working with here is Lname...
Im trying to find how to develop a query that lists for every letter of the alphabet how many members' last names start with this letter.
So the list will have 2 columns whereby the 1st contains letters of the alphabet, with the 2nd containing numbers showing a number representing how many members last name (Lname) starts with that particular letter.
So far ive got:
select SUBSTR(Lname,0,1), count(*)
from Member group by Lname;