michaellunsford Posted September 10, 2006 Share Posted September 10, 2006 if I use the GROUP BY command, it returns the first record in each group -- can I dig deeper and get all of the records? Quote Link to comment https://forums.phpfreaks.com/topic/20307-how-to-access-group-by-items/ Share on other sites More sharing options...
extrovertive Posted September 10, 2006 Share Posted September 10, 2006 If you want to get all the record, why use group? GROUP is maily use for aggregrating stuff, like MAX, MIN, COUNT, etc. Quote Link to comment https://forums.phpfreaks.com/topic/20307-how-to-access-group-by-items/#findComment-89458 Share on other sites More sharing options...
michaellunsford Posted September 10, 2006 Author Share Posted September 10, 2006 Yeah, I guess I need a second query. Quote Link to comment https://forums.phpfreaks.com/topic/20307-how-to-access-group-by-items/#findComment-89506 Share on other sites More sharing options...
fenway Posted September 10, 2006 Share Posted September 10, 2006 Any time you use an aggregate function, you "lose" all information about the non-grouped by columns, and you get an arbitrary one back. Quote Link to comment https://forums.phpfreaks.com/topic/20307-how-to-access-group-by-items/#findComment-89527 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.