Links

Saturday, 16 April 2011

How to use OR and AND Operator in single Query?

Select * from Table_name
Where 
Column_name='value' AND (Column_name='value' OR Column_name='value')
e.g
Select * from Techology 
Where 
Part_name='hammer' and(partno=1 or city='chandigarh')

No comments:

Post a Comment