What is the difference between DISTINCT and use Group by in php
Started on: 20 December 12
Participants: 1
Is it better to use group by to filter dublicate data or use distinct ?
Which one relativly better in huge data?
Please give your suggestions
Which one relativly better in huge data?
Please give your suggestions
This challenge is listed under
Development & Implementations
and Data & Information Management
Community
Related Posts:
Initiator
1 Suggestion
Use DISTINCT if you just want to remove duplicates. Use GROUPY BY if you want to apply aggregate operators (MAX, SUM, GROUP_CONCAT, ..., or a HAVING clause).