in reply to Re^2: How many Select Querie is considered too much?
in thread How many Select Querie is considered too much?

Wouldn't you need a 'group by' in there?
SELECT read, COUNT(*) FROM Results WHERE user_id = ? AND read in ('2','3','4') GROUP BY read
I know Oracle really well, so it's possible that I'm just being Oracle-centric :)

Trek