Given a table:

Im trying to select the rows where a userid shows up more then X number of times, lets say >2, OR the value of a column is >2. In the above table I'm hoping for count > 2

So in the above database, the result of the query would give me userid 1, 2, 3

I've gotten the following query to get the instances where the occurences of userid > 2, but can I also somehow include the times where the column value count > 2 is also true?

SELECT *
FROM marktable
WHERE userid IN (
  SELECT userid
  FROM marktable
  GROUP BY userid
  HAVING COUNT(*) > 2
);

CodePudding user response：

Add another condition in the WHERE clause:

SELECT *
FROM marktable
WHERE count > 2
   OR userid IN (
     SELECT userid
     FROM marktable
     GROUP BY userid
     HAVING COUNT(*) > 2
   );

Or, if you want all the rows of a userid that has a row with count > 2:

SELECT *
FROM marktable
WHERE userid IN (
  SELECT userid
  FROM marktable
  GROUP BY userid
  HAVING COUNT(*) > 2 OR MAX(count) > 2
);

See the demo.