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!