group by period of time

• Nili S

  Right there with Babe

  Points: 795

  More actions

  June 24, 2007 at 9:25 am

  #68587

  Hello,

  I have a table containing large data, and one of the fields is a date field. Every minute there are hundreds of rows in the table.

  I want to query only data that was inserted last every, lets say, 10 minutes, meaning: query one row per period of 10 minutes.

  How do I group by a period of time, so that I can get the max(date) for each 10 minutes? Can it be done using simple SQL query (since I need for it to work on both Oracle and SQL Server DB) or do I have to use a TSQL/PLSQL function?

  Thanks.

  Nili.

• Jeff Moden

  SSC Guru

  Points: 1004363

  More actions

  June 24, 2007 at 10:18 am

  #714813

  CROSS POST... see the following

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=376138&post=true

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)