SQL multiple columns in IN clause

by

You could do like this:

SELECT city FROM user WHERE (firstName, lastName) IN (('a', 'b'), ('c', 'd'));

The sqlfiddle.

More Related Contents:

  1. Search All Fields In All Tables For A Specific Value (Oracle)
  2. Select First Row of Every Group in sql [duplicate]
  3. Oracle: how to UPSERT (update or insert into a table?)
  4. Get top results for each group (in Oracle)
  5. Comparing Dates in Oracle SQL
  6. Oracle SQL query: Retrieve latest values per group based on time [duplicate]
  7. ORA-12560: TNS:protocol adaptor error
  8. GROUP BY / aggregate function confusion in SQL
  9. Oracle “(+)” Operator
  10. How do you create a temporary table in an Oracle database?
  11. What exactly do quotation marks around the table name do?
  12. How can I get column names from a table in Oracle?
  13. How to store only time; not date and time?
  14. How does GROUP BY work?
  15. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  16. SQL Error: ORA-01861: literal does not match format string 01861
  17. Determine Oracle null == null
  18. How to anticipate and escape single quote ‘ in oracle
  19. INSERT SELECT statement in Oracle 11G
  20. Oracle insert if row does not exist
  21. Display names of all constraints for a table in Oracle SQL
  22. SQL Oracle LEFT JOIN and SUBQUERY error: ORA-00905: missing keyword
  23. Does ‘Select’ always order by primary key?
  24. Query json dictionary data in SQL
  25. How to use a dynamic parameter in a IN clause of a JPA named query?
  26. How to check if a column exists before adding it to an existing table in PL/SQL?
  27. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  28. Why doesn’t Oracle SQL allow us to use column aliases in GROUP BY clauses?
  29. Exporting a CLOB to a text file using Oracle SQL Developer
  30. Oracle ‘Partition By’ and ‘Row_Number’ keyword

Leave a Comment