"dude! 30 member in one month with a top ranked site on planetmysql.com.... I think this answers your original question!"
A great place to be!
Zachary Buckholz's Discussions
SQL query help
2 Replies
I am updating my Drinks Dictionary iPhone app which uses a sqlite database. I need to create a query to count how many items begin with the letter 'a', 'b', 'c', etc....I can get as far as 'select…Continue
Started this discussion. Last reply by Zachary Buckholz Sep 13, 2009.
Zachary Buckholz's Page
Gifts Received
Zachary Buckholz has not received any gifts yet
Latest Activity
"Thanks Sarah - you got me where I wanted to be.
sqlite> select count(*), substr(name,1,1) from drinks group by…"
"Hi Zach,
I believe what you want is something like:
SELECT count(*), name FROM Drinks GROUP BY left(name,1);
-Sarah"
SQL query help
I am updating my Drinks Dictionary iPhone app which uses a sqlite database. I need to create a query to count how many items begin with the letter 'a', 'b', 'c', etc....I can get as far as 'select DISTINCT substr(name,1,1) FROM drinks;How can I apply a GROUP BY clause or something else so in one query I can get every unique first character and a count of how many drinks start with that character?ThanksZachSee More
Comment Wall (1 comment)
- At 9:09pm on September 22, 2009,
Chris said…
- dude! 30 member in one month with a top ranked site on planetmysql.com.... I think this answers your original question!
© 2024 Created by Chris.
Powered by
