SQL query: Simulating an “AND” over several rows instead of sub-querying

by 
SELECT contentID
FROM tags
WHERE tagID in (334, 338, 342)
GROUP BY contentID
HAVING COUNT(DISTINCT tagID) = 3


--In general
SELECT contentID
FROM tags
WHERE tagID in (...) --taglist
GROUP BY contentID
HAVING COUNT(DISTINCT tagID) = ... --tagcount

More Related Contents:

  1. What is the result of following SQL Query?
  2. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  3. Join vs. sub-query
  4. Can I use CASE statement in a JOIN condition?
  5. What is the difference between Left, Right, Outer and Inner Joins? [duplicate]
  6. SQL join: selecting the last records in a one-to-many relationship
  7. Subqueries vs joins
  8. Does the join order matter in SQL?
  9. Difference between left join and right join in SQL Server [duplicate]
  10. What is the difference between JOIN and UNION?
  11. Filter Table Before Applying Left Join
  12. SQL Join Differences
  13. Difference between natural join and inner join
  14. Are “from Table1 left join Table2” and “from Table2 right join Table1” interchangeable?
  15. Inner Join vs Natural Join vs USING clause: are there any advantages?
  16. Natural join in SQL Server
  17. Including null values in an Apache Spark Join
  18. Is a JOIN faster than a WHERE?
  19. Select only rows by join tables max value
  20. Is it true that using INNER JOIN after any OUTER JOIN will essentially invalidate the effects of OUTER JOIN?
  21. What is semi-join in database?
  22. MySQL: GROUP_CONCAT with LEFT JOIN
  23. Merge two rows in SQL
  24. Joining multiple tables in SQL
  25. What is the difference between a LATERAL JOIN and a subquery in PostgreSQL?
  26. sql sum data from multiple tables
  27. Why do multiple-table joins produce duplicate rows?
  28. SQL server join tables and pivot
  29. IN vs. JOIN with large rowsets
  30. SQL join on multiple columns in same tables

Leave a Comment