Mysql Counting the consecutive rows that match

by

I loaded a SQLfiddle here: http://sqlfiddle.com/#!2/5349a/1 However, in your sample data, you had two ID=5. I made it unique. Also my SQLFiddle data doesn’t match yours anymore since I changed some values to make sure it worked. Have fun with it 🙂 (This works looking at the largest ID value for the sequence)

Try this:

SELECT COUNT(*)
FROM (
  SELECT Subject, MAX(ID) AS idlimit
  FROM t
  GROUP BY Subject
  ORDER BY MAX(ID) DESC
  LIMIT 1,1) as Temp
JOIN t
  ON Temp.idlimit < t.id

More Related Contents:

  1. Complex Count in MySQL
  2. Most efficient way to get table row count
  3. MySql Count cannot show 0 values
  4. Speeding up row counting in MySQL
  5. Order by COUNT per value
  6. Mysql count instances of substring, then order by
  7. mysql: get record count between two date-time
  8. COUNT(*) from multiple tables in MySQL
  9. Why the rows returns by “explain” is not equal to count()?
  10. How to get the count of each distinct value in a column? [duplicate]
  11. MYSQL Left Join COUNTS from multiple tables
  12. Count with IF condition in MySQL query
  13. MySQL – Using COUNT(*) in the WHERE clause
  14. How do I add two count(*) results together on two different tables?
  15. How to get a ranking result for special record in mysql [closed]
  16. How to reset AUTO_INCREMENT in MySQL
  17. MySQL Server has gone away when importing large sql file
  18. What is MySQL row order for “SELECT * FROM table_name;”?
  19. MySQL Like multiple values
  20. Error: select command denied to user ”@” for table ”
  21. Problems with contenttypes when loading a fixture in Django
  22. MySQL: Sort GROUP_CONCAT values
  23. Entity Framework wizard crashes on MySQL
  24. Mysql to select month-wise record even if data not exist
  25. Facebook like notifications tracking (DB Design)
  26. MySQL – how many rows can I insert in one single INSERT statement?
  27. How do I show the schema of a table in a MySQL database?
  28. MySQL Stored Procedure Error Handling
  29. Mysql delete statement with limit
  30. How can I cast an int to a bit in MySQL 5.1?

Leave a Comment