Question Regarding Subquery

Question

Dear Frnds,
i want to use Sub Querie's in my stored Procedures.
can any1 tell or show me how to make the Sub Queries(Syntax and example) and what are the points to remember while making a Subqueries.
Please need your help.

Thanks & Regards,
Aamir