Follow this topic

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

1

10

No rows in employees database

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

0

6

Resolved: Queries with LIKE('Mar%') and LIKE('Mar_') are returning the output with 1000 rows each