Operand Should Contain 1 Column – MySQL NOT IN

by

There’s always this:

select *
from campaigns 
where id not in (
    select id_campaign from (
        select e.id_campaign as id_campaign, d.frequency, e.id
        from campaigns d left join served e on d.id = e.id_campaign
        where d.status="Active"
        group by e.id_campaign 
        having count(e.id) < d.frequency 
    )
)

More Related Contents:

  1. MySQL – Operand should contain 1 column(s)
  2. MySQL error 1241: Operand should contain 1 column(s)
  3. SQL Query needed for fetch value from Two identical table but not fully identical table
  4. Error related to only_full_group_by when executing a query in MySql
  5. SQL split values to multiple rows
  6. Get records with max value for each group of grouped SQL results
  7. How to declare a variable in MySQL?
  8. How to populate a table with a range of dates?
  9. MySQL Cannot Add Foreign Key Constraint
  10. Grouping into interval of 5 minutes within a time range
  11. SQL counting all rows instead of counting individual rows
  12. How do I select an entire row which has the largest ID in the table?
  13. Adding a leading zero to some values in column in MySQL
  14. Using SQL to determine word count stats of a text field
  15. Update one MySQL table with values from another
  16. MySQL/MariaDB – order by inside subquery
  17. How to transpose mysql table rows into columns
  18. View’s SELECT contains a subquery in the FROM clause
  19. MySQL incorrect key file for tmp table when making multiple joins
  20. Does the order of conditions in a WHERE clause affect MySQL performance?
  21. Difference between these two joining table approaches?
  22. MySQL Stored Procedures not working with SELECT (basic question)
  23. MySQL query, MAX() + GROUP BY
  24. ERROR 1148: The used command is not allowed with this MySQL version
  25. MySQL export into outfile : CSV escaping chars
  26. Simple Random Samples from a MySQL Sql database
  27. ALTER table – adding AUTOINCREMENT in MySQL
  28. MySQL Select minimum/maximum among two (or more) given values
  29. Convert SQL Server query to MySQL [duplicate]
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment