Nested SELECT is used when some select query is used under a select query like SELECT * FROM (SELECT * FROM TABLE)
