Skip to content
Advertisement

Multiple conditions on the same column in the WHERE clause

I have a table something like this –

How do I return the names of users where PropertyID = 13 AND PropertyVal='Business Development Analyst'AND PropertyID = 11 AND PropertyVal = 'Chicago'. How do I do multiple where clauses for the same column?

Edit: I need the result set to look like this –

Advertisement

Answer

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement