Follow this topic

Last answered:

07 Dec 2021

Posted on:

09 Nov 2021

0

why employees have the same number emp_no it shouldnt be unique?

in SQL / Duplicate Records

hi guys ;
I'm a little bit confused currently about dept _no and emp_no like why there are 2 employee with the same number ???
best regards

1 answers ( 0 marked as helpful)

Instructor

Posted on:

07 Dec 2021

0

Hi Mehdi!

Thanks for reaching out!

Could you please elaborate on your question and try explaining it through particular examples? This could help us assist you better. Thank you!

Hope this helps.
Best,
Martin

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?

Davide Sanchioni

0

14

Resolved: SQL Exam question number 29

1

14

Resolved: employees.sql database not found in resources

Abdelrahman Samy

0

14

Resolved: why this code not valid

Mohamed AbdulHalim

0

12

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

Christopher Watts

1

12

Error Code: 1364. Field 'customer_id' doesn't have a default value

0

12

Resolved: SELECT first_name FROM employees GROUP BY first name did not work properly

1

10

No rows in employees database

0

10

Resolved: Why is the highlighted practice not considered a best practice?

0

8

Resolved: SQL Task- getting the names of all the managers who have an AVG salary of 85k+

1

8

Employees DB has no data

Maxime Darbouze

0

8

I wrote the same command that is the sql file and it did not work