User Profile

Collapse

Profile Sidebar

Collapse
izamu
izamu
Last Activity: Jan 18 '13, 06:29 AM
Joined: Apr 11 '11
Location: Washington DC
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • izamu
    replied to count at each change in value
    in MySQL
    Thanks Luuk, didn't see the reply until today
    See more | Go to post

      Leave a comment:

    • izamu
      started a topic count at each change in value
      in MySQL

      count at each change in value

      I have a million records or so I need to count how many consecutive records have the same value. At each change in value I initiate the count from one again. this summary will be used to perform statistical analysis down the road.
      The output of this excercise will be a summary that tells me count at each tempreture but without sorting the raw data because the time and date of tempreture reading is importat, so just to be clear I can't sort...
      See more | Go to post
      Last edited by izamu; Feb 21 '12, 07:55 PM. Reason: additional info
      • izamu
        started a topic compare rows. do something when value changes in a particular column
        in MySQL

        compare rows. do something when value changes in a particular column

        I want to compare the values within a column and aggregate (count) at each change in value. so for example column "A" has a series of numbers like (1,1,1,2,1,5,2, 2,5) the aggregation should be the counts 3,1,1,1,2,1. 3 of 1, followed by 1 of value 2, followed by 1 value 1...

        somebody suggested duplicating the target column and shifting in down by one row and then comparing the values between the original column and the new...
        See more | Go to post
        No activity results to display
        Show More
        Working...