select to return next value

• emcdonald

  SSC Rookie

  Points: 38

  More actions

  October 4, 2002 at 10:09 am

  #158200

  I need to do a SELECT statement that will return results of different value in order by datetime stamp. So, I have the following select that returns all values:

  select distinct(TimePointDateTime) 'Time of Condition', sevs 'Condition/Severity' from severities where SeriesID = '2033305148272264613' and TimePointDateTime >= 'Sep 15 2002 00:01AM' and TimePointDateTime <= 'Sep 30 2002 23:59PM' order by TimePointDateTime";

  The problem is the sevs maybe the same value but the TimePointDateTime value will not be. If the SEVS value is the same value I do not want it to return until it is different.

  Hope this makes sense.

• October 29, 2002 at 12:00 pm

  This was removed by the editor as SPAM

• Klaas-Jan

  SSCrazy

  Points: 2297

  More actions

  October 30, 2002 at 2:24 am

  #439776

  Hi, if you want to return the minimum timepointdatetime you could do something like this.

  select min(TimePointDateTime) ,

  sevs

  from test

  where seriesid='2033305148272264613'

  group by sevs