Re: Check if there 6 last records of same type without gaps - Mailing list pgsql-general

Of course you need the played field you relied on it in the order by clause. You can use the result of a select in a from clause of another select.

SELECT SUM(skips) from (SELECT CASE WHEN action='skip' THEN 1 ELSE 0 END as skips, played

         FROM words_moves
         WHERE gid = 3
         ORDER BY played DESC

         LIMIT 6) as skipscount;