• Learn
    • Courses
    • Career Tracks
    • Projects
    • Upcoming Courses
  • Certificates
    • Career Track Certificate
    • Course Certificate
  • Resources
    • All Resources
    • Course Notes
    • Templates
    • Infographics
    • Career Guides
    • Practice Exams
    • Blog
    • Success Stories
    • Calculators
  • Pricing
  • For Business
    • Team Plan
    • Live Training
  • Login
  • Sign Up
Log In Sign Up
Follow this topic
Share
Niranjan S
Last answered:

21 Jun 2023

Posted on:

17 Jun 2023

0

Wrong solution obtained.. Got 3007 rows instead

in SQL / HAVING

1 answers ( 0 marked as helpful)
Tsvetelin Tsonkov
Instructor
Posted on:

21 Jun 2023

0

Hi Niranjan!
Thanks for reaching out.


You need to use the GROUP BY clause with only the emp_no column.


Hope this helps.
Best,
Tsvetelin

Submit an 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?
Juan Pablo Cofano
1
12
Hi, i think this practice is wrong here in assignment select distinct
Mohamed AbdulHalim
0
10
Resolved: Playing the text in the video does not work, although I have cc enabled, what is the solution please
Matt Birch
1
10
No rows in employees database
hazem gamal
0
10
Resolved: i always retrieve 36 rows !!
Olayemi Hafeez Rufai
1
8
I GOT AN ERROR IN RUNNING CODE. I COULDN'T FIX IT
Oriji Sandra Onyinyechi
0
6
The solution has two select statement
Kiran B
0
6
Resolved: Queries with LIKE('Mar%') and LIKE('Mar_') are returning the output with 1000 rows each

All the Data Science Courses You Need

About

  • About Us
  • Instructors
  • Contact Us
  • Pricing

Learn

  • Courses
  • Career tracks
  • Career Certificate
  • Course Certificate

Resources

  • Course Notes
  • Templates
  • Career Guides
  • Practice exams
  • Calculators
  • Blog

Platform

  • Success stories
  • Q&A Hub
  • Help Center
  • Verify Certificate
© 2023 365 Data Science. All Rights Reserved.
Sitemap Terms of Use Privacy Policy Cookies