corkg Posted July 17, 2008 Share Posted July 17, 2008 Is it possible to run a sql query that will group all months the dates are ordered dd/mm/yyyy in the database how can I group the months together? Thanks Quote Link to comment Share on other sites More sharing options...
Xurion Posted July 17, 2008 Share Posted July 17, 2008 SELECT * FROM table GROUP BY date Quote Link to comment Share on other sites More sharing options...
fenway Posted July 17, 2008 Share Posted July 17, 2008 SELECT * FROM table GROUP BY date First, you can't select * with a GROUP BY. Second, I don't even understand the question. Quote Link to comment Share on other sites More sharing options...
Xurion Posted July 18, 2008 Share Posted July 18, 2008 I'm confused - I just successfully did a SELECT * with a GROUP BY :-\ Quote Link to comment Share on other sites More sharing options...
fenway Posted July 23, 2008 Share Posted July 23, 2008 I'm confused - I just successfully did a SELECT * with a GROUP BY :-\ You can do it, but anything other than the group-by'ed column will be meaningless! Quote Link to comment 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.