How to use where clause on two conditions like I I need where city = xxxx and where street = yyy

Answer 1

You already have the answer in your question. You just wrap the values with single quotes (assumed CHAR, or VARCHAR family).

WHERE city = 'xxxx' AND street = 'yyy'

AND operator ensures all its operands satisfies.

OR operator needs only one of its operands to satisfy.

Answer 2

Nandhakumar G

Can you elaborate a bit more for ehat you are asking?

Answer 3

I have a table like employees I'd, city and street if I have listed on 4 city same and only 2 employees I'd on same street out of 10 employees I'd but I need 2 same street on same city so how to write a query

Answer 4

where city=xxxx or street=yyy

Answer 5

Nandhakumar G
I can't understand your description, can you explain in more simple way? I can't imagine the tabls data ...