get first occurrence of last changed value of a column [closed]

by

Maybe you can try with something like this:

select t.value into @lastValue
from test t 
order by t.date desc 
limit 1;
    
select t.*
from test t
where t.value = @lastValue
  and t.date > (select max(tt.date) from test tt where tt.value <> @lastValue)
order by t.date asc
limit 1;

You can test on this db<>fiddle

More Related Contents:

  1. Which DB technology is sued to solve the following search issue? [closed]
  2. What is better subquery vs literal on IN clause in mysql
  3. When to use single quotes, double quotes, and backticks in MySQL
  4. How do I import an SQL file using the command line in MySQL?
  5. How to select the nth row in a SQL database table?
  6. MySQL – How to unpivot columns to rows?
  7. How to join two tables mysql?
  8. UPDATE multiple rows with different values in one query in MySQL
  9. MySQL SELECT only not null values
  10. Multiple Updates in MySQL
  11. SQL split comma separated row [duplicate]
  12. Detect if value is number in MySQL
  13. Difference between two dates in MySQL
  14. MySQL – Subtracting value from previous row, group by
  15. How do I restore a dump file from mysqldump?
  16. How do I create a sequence in MySQL?
  17. MySQL search and replace some text in a field
  18. How to count items in comma separated list MySQL
  19. Group mysql query by 15 min intervals
  20. Error Code: 1406. Data too long for column – MySQL
  21. MySQL order by “best match”
  22. Using Count to find the number of occurrences
  23. Is there any reason to worry about the column order in a table?
  24. Checking a table for time overlap?
  25. Does mysql have the equivalent of Oracle’s “analytic functions”?
  26. MySQL INSERT INTO … VALUES and SELECT
  27. MYSQL select DISTINCT values in two columns
  28. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  29. Replace null with 0 in MySQL
  30. SQL query with avg and group by

Leave a Comment