Is distinct work as group by in SQL !? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

Is distinct work as group by in SQL !?

syntax of SQL

18th May 2017, 11:17 AM
Brahim Chai
Brahim Chai - avatar
2 Answers
+ 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