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?

Mohamed AbdulHalim

0

12

Resolved: Playing the text in the video does not work, although I have cc enabled, what is the solution please

Juan Pablo Cofano

2

12

Hi, i think this practice is wrong here in assignment select distinct

0

10

Resolved: i always retrieve 36 rows !!

1

10

No rows in employees database

Olayemi Hafeez Rufai

1

8

I GOT AN ERROR IN RUNNING CODE. I COULDN'T FIX IT

rafi ullah waseem

1

8

ROLLBACK is affecting 0 rows

0

8

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

1

6

The output shows zero rows returned when you Rollback?

Oriji Sandra Onyinyechi

0

6

The solution has two select statement

0

6

does not rollback and i don't know what i have to do , i do all sug solution with no result

rafi ullah waseem

5

6

If your getting EROOR CODE 1055: Try This Code Instead!