Learn
Courses
Career Tracks
Upcoming Courses
Certificates
Career Track Certificate
Course Certificate
Resources
All Resources
Course Notes
Templates
Infographics
Career Guides
Practice Exams
Blog
Success Stories
Pricing
Business
Team Plan
Live Trainings
Log In
Sign Up
Follow this topic
Share
Mayank Mittal
Last answered:
05 Oct 2022
Posted on:
29 Sept 2022
0
why distinct in this case doesn't work same as group by
in
SQL
/
Duplicate Records
3 answers ( 0 marked as helpful)
Tsvetelin Tsonkov
Instructor
Posted on:
30 Sept 2022
0
Mayank Mittal
Posted on:
30 Sept 2022
0
Tsvetelin Tsonkov
Instructor
Posted on:
05 Oct 2022
0
Submit an answer
Submit answer
related questions
Marcus Wern Han Leong
2
16
Why did you not do not null, primary key and auto increment for customer id in the solution?
yenni kosasih
0
14
error code 1140 : in aggregated query without group by
Christopher Watts
0
12
Error Code: 1364. Field 'customer_id' doesn't have a default value
Juan Pablo Cofano
1
12
Hi, i think this practice is wrong here in assignment select distinct
Alessandro Imbrìaco
3
10
Resolved:
The page shown in the video doesn't exist anymore
Maxime Darbouze
0
8
I wrote the same command that is the sql file and it did not work
Saeed Ehsanfar
0
6
Need clarification on why using e.emp_no < 10011 in the WHERE clause
Sachintha Adikari
1
6
Why can't we just use IN?