+ 1
Is distinct work as group by in SQL !?
syntax of SQL
2 Réponses
+ 2
Not really. Distinct is intended to return a recordset whose records are unique. Group by is intended to build "packets" of records, and to compute aggregate functions, such as min, max, count, avg...
+ 1
what the deferent between
Select name from people Group by name ;
and :
Select distinct nam From people ;