+ 1

I've written some query does this all are good for returning same result or some query will give different rows?

Query 1 Select student from enrolled where student in(select student from paid) Query 2 Select student from paid where student in (select student from enrolled) Query 3 Select E.student from enrolled E, paid P where E.student = P.student Query 4 Select student from paid where exists (select * from enrolled where enrolled.student = paid.student) Which will gives same result and why

6th Sep 2019, 4:49 AM
Preity
Preity - avatar
1 Resposta
+ 1
yamila blanco *please remove your spam Please do not create spam threads or add spammy comments to an existing thread. Both are seen as negative behavior. Thanks and happy coding https://code.sololearn.com/Wv5gTHy1N6Ji/?ref=app
1st Dec 2020, 1:51 PM
BroFar
BroFar - avatar