Today, I have provided an article showing you how to add a subquery to a select statement in SQL Server 2012.
www.c-sharpcorner.com