SQL: how to select a single id (“row”) that meets multiple criteria from a single column

by

Try this:

Select user_id
from yourtable
where ancestry in ('England', 'France', 'Germany')
group by user_id
having count(user_id) = 3

The last line means the user’s ancestry has all 3 countries.

More Related Contents:

  1. How do I UPDATE from a SELECT in SQL Server?
  2. SQL update from one Table to another based on a ID match
  3. SQL join: selecting the last records in a one-to-many relationship
  4. COUNT(*) vs. COUNT(1) vs. COUNT(pk): which is better? [duplicate]
  5. SQL SELECT WHERE field contains words
  6. What is the difference between using a cross join and putting a comma between the two tables?
  7. Return a value if no record is found
  8. SQL WHERE ID IN (id1, id2, …, idn)
  9. How can I select from list of values in Oracle
  10. Are there any way to execute a query inside the string value (like eval) in PostgreSQL?
  11. Select TOP X (or bottom) percent for numeric values in MySQL
  12. Fastest way to determine if record exists
  13. How to kill a running SELECT statement
  14. How do I select all the columns from a table, plus additional columns like ROWNUM?
  15. DATEDIFF function in Oracle [duplicate]
  16. Best way to do nested case statement logic in SQL Server
  17. How to select multiple rows filled with constants?
  18. How to select only the first rows for each unique value of a column?
  19. How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
  20. Why postgres returns unordered data in select query, after updation of row?
  21. MySQL: Select DISTINCT / UNIQUE, but return all columns?
  22. SQL column reference “id” is ambiguous
  23. SQL SELECT from multiple tables
  24. Can select * usage ever be justified?
  25. How to select records without duplicate on just one field in SQL?
  26. how does SELECT TOP works when no order by is specified?
  27. Select distinct from multiple fields using sql
  28. SQL: Select rows with a column value that occurs at least N times?
  29. “SELECT *” vs “SELECT ” for performance
  30. Finding unmatched records with SQL

Leave a Comment