SQL Subquery: Filter entries that return no rows

SQL Subquery: Filter entries that return no rows

References

Reference NO 1

http://stackoverflow.com/questions/15201518/sql-subquery-filter-entries-that-return-no-rows

Reference NO 2

http://stackoverflow.com/questions/1406215/sql-select-where-not-in-subquery-returns-no-results

Reference NO 3

http://www.postgresql.org/docs/9.1/static/functions-subquery.html

Reference NO 4

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/sqlp/rbafyhowsub.htm

Reference NO 5

http://www.codespaces.com/blog/2011/02/24/oracle-limiting-the-number-of-records-like-top-n-limit/

Reference NO 6

http://dev.mysql.com/doc/refman/5.0/en/row-subqueries.html

Reference NO 7

http://blog.tanelpoder.com/2013/08/13/oracle-12c-scalar-subquery-unnesting-transformation/

Reference NO 8

http://support.sas.com/documentation/cdl/en/sqlproc/62086/HTML/default/viewer.htm#a001361644.htm