SQL query that gives distinct results that match multiple columns

by 
SELECT document_id
FROM table
WHERE tag = 'tag1' OR tag = 'tag2'
GROUP BY document_id
HAVING COUNT(DISTINCT tag) = 2

Edit:

Updated for lack of constraints…

More Related Contents:

  1. Solutions for INSERT OR UPDATE on SQL Server
  2. MySQL query finding values in a comma separated string
  3. SQLite INSERT – ON DUPLICATE KEY UPDATE (UPSERT)
  4. How to update selected rows with values from a CSV file in Postgres?
  5. Strings as Primary Keys in SQL Database [closed]
  6. Can table columns with a Foreign Key be NULL?
  7. Deleting duplicate rows from sqlite database
  8. Decision between storing lookup table id’s or pure data
  9. How Can I use “Date” Datatype in sql server?
  10. How to replace a string in a SQL Server Table Column
  11. How many rows in a database are TOO MANY?
  12. Primary key or Unique index?
  13. How to get a list of column names on Sqlite3 database?
  14. How to run a stored procedure in sql server every hour?
  15. Composite Primary key vs additional “ID” column?
  16. Questions every good Database/SQL developer should be able to answer [closed]
  17. Why do you create a View in a database?
  18. Logging ALL Queries on a SQL Server 2008 Express Database?
  19. Best database field type for a URL
  20. How to find rows in one table that have no corresponding row in another table
  21. sql unique constraint on a 2 columns combination
  22. SQL query to select distinct row with minimum value
  23. Oracle (Old?) Joins – A tool/script for conversion?
  24. sqlite select with condition on date
  25. ‘Lost update’ vs ‘Write skew’
  26. row-level trigger vs statement-level trigger
  27. How do I change db schema to dbo
  28. Query a Table’s Foreign Key relationships
  29. How to store a list in a db column
  30. Copy table structure to new table in sqlite3

Leave a Comment