SQL: How do you select only groups that do not contain a certain value?

by

One way:

SELECT RESTAURANT_NO FROM restaurant WHERE RESTAURANT_NO NOT IN
(SELECT RESTAURANT_NO FROM restaurant WHERE RESTAURANT_LOCATION = 'City C')

More Related Contents:

  1. Reason for Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause [duplicate]
  2. Using group by on multiple columns
  3. Is there any difference between GROUP BY and DISTINCT
  4. How to use count and group by at the same select statement
  5. must appear in the GROUP BY clause or be used in an aggregate function
  6. GROUP BY to combine/concat a column [duplicate]
  7. Concat groups in SQL Server [duplicate]
  8. JOIN two SELECT statement results
  9. Ms Access Query: Concatenating Rows through a query
  10. SQL query for finding records where count > 1
  11. Group by month and year in MySQL
  12. SQL Group by & Max
  13. SQL to Entity Framework Count Group-By
  14. SQL GROUP BY CASE statement with aggregate function
  15. Mysql: how to select groups having certain values?
  16. MySQL #1140 – Mixing of GROUP columns
  17. SQL Server Update Group by
  18. PostgreSQL Where count condition
  19. Huge performance difference when using GROUP BY vs DISTINCT
  20. sql group by only rows which are in sequence
  21. GROUP BY without aggregate function
  22. MySQL GROUP BY behavior
  23. Conditional SQL count
  24. Get values from first and last row per group
  25. How to return a incremental group number per group in SQL
  26. SQL query to group by day
  27. How to get list of values in GROUP_BY clause?
  28. Conversion failed when converting the varchar value ‘simple, ‘ to data type int
  29. Why doesn’t Oracle SQL allow us to use column aliases in GROUP BY clauses?
  30. How to group by a Calculated Field

Leave a Comment