Discussion :: Introduction to SQL - General Questions (Q.No.13)
| Ankur said: (Nov 26, 2010) | |
| select <column_name> from <table_name> where <column_name>=(select <column_name> from <table_name2); |
|
| Yash Nahar said: (Sep 29, 2014) | |
| Could you please explain it in more detail? | |
| Santosh Pakhare said: (Aug 9, 2015) | |
| Sub-query always enclosed in parenthesis i.e ( ). | |
| Pritam Gupta said: (Nov 19, 2015) | |
| select * from emp where emp_id=123 AND (emp_name='abc ' OR emp_add='xyz'); | |
| Etenduk Jackson said: (Nov 20, 2016) | |
| You are correct @Pritam. Subquery are statement enclose () for pre-definition. |
|
Post your comments here:
Name *:
Email : (optional)
» Your comments will be displayed only after manual approval.