Ahmed Lotfy
Last answered:

20 Jan 2023

 Posted on:

19 Jan 2023
0

alternative solution same results . Is it valid?

in SQL / SQL Subqueries with IN nested inside WHERE

image.png

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

20 Jan 2023
0

Hi Ahmed!
Thanks for reaching out.

Yes, this is a valid solution. The structure of the query is not recommended as there are a lot of subqueries. This makes the performance slower. Anyway, congratulations to the alternative solution!

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?
Maxime Darbouze
0
8
I wrote the same command that is the sql file and it did not work
Abdelrahman Samy
0
8
Resolved: why this code not valid
Ahmed Hesham
0
6
does not rollback and i don't know what i have to do , i do all sug solution with no result
Batool Osama Khalid
0
6
Resolved: INNER JOIN results .....
Yogesh Batra
1
6
Resolved: Given solution didn't work and showing error
Pawee Chiranothai
0
6
Why does drawing data from dept_manager_dup table get different results?
Oriji Sandra Onyinyechi
0
6
The solution has two select statement