SQL sub query single value

How to write Subquery to Return Single Value

Sub queries are like queries with in the query. You can write subquery such that it will return single value or multiple values. Read more example and explanation.