+ 1

Is distinct work as group by in SQL !?

syntax of SQL

18th May 2017, 11:17 AM
Brahim Chai
Brahim Chai - avatar
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...
18th May 2017, 12:24 PM
Álvaro
+ 1
what the deferent between Select name from people Group by name ; and : Select distinct nam From people ;
18th May 2017, 12:29 PM
Brahim Chai
Brahim Chai - avatar