Mock interview 4 - sub query needed
In Mock interview 4, is the su query really needed? can’t you do the same by adding the where clause in the first query?
1 answers ( 0 marked as helpful)
You can't reference a new alias in a WHERE clause within a query, and you can't use a windows function in a query, so I think it does need the sub query here!
Submit an answer
GRAB 1 OF 200 ANNUAL PLANS UP TO
72% OFF
72% OFF