On executing below 2 queries I’m getting different results. Just wanted to understand the difference between both the queries.
SELECT * FROM SAMPLE WHERE REGNO NOT IN ( SELECT DISTINCT ID FROM STUDENT)
SELECT * FROM SAMPLE WHERE REGNO NOT IN ( SELECT RAW ID FROM STUDENT)
RAW will give you an array of just IDs; without the RAW keyword the results are objects. Compare the results from the two sub-queries run directly and you’ll see the difference.