select max(date) GROUP BY SEQ NO in oracle RSS

• • Reply
  

  -_-

  Member

  375 Points

  1033 Posts

  select max(date) GROUP BY SEQ NO in oracle

  Nov 19, 2012 06:57 AM|LINK

  my table contain 3 column (id, seq. no and creation date)

  how can i filter the max. creation date of each seq. no ,make sure that each seq. no. only has 1 record in result set in ORacle package

  for example

  id seq_no   create_date 1  1        11-09-2012 2  1        18-09-2012 3  2        11-09-2012

  my expected result set is filter id =2 and id=3

   

  any sql reference for me.

• • Reply
  

  Lannie

  Contributor

  3724 Points

  726 Posts

  Re: select max(date) GROUP BY SEQ NO in oracle

  Nov 19, 2012 07:07 PM|LINK

  Oracle Analytics using windowing functionality

• • Reply
  

  -_-

  Member

  375 Points

  1033 Posts

  Re: select max(date) GROUP BY SEQ NO in oracle

  Nov 20, 2012 06:12 AM|LINK

  Lannie

  Oracle Analytics using windowing functionality

   

  each seq no has many record with different create_date,

  how can i extract data that is max(create_date) by seq no , so that each seq no has 1 record with max create date of that seq no.

• • Reply
  

  Lannie

  Contributor

  3724 Points

  726 Posts

  Re: select max(date) GROUP BY SEQ NO in oracle

  Nov 22, 2012 04:38 AM|LINK

  Oracle analytics with windowing functions can do that.

  Show us a sample set of data like 10 lines, and your desired output for those 10 lines,

  and we can show you Oracle Analytics.

  Or you can read about Oracle Analytics in many places online or books, like the chapter on the subject in:

  http://www.amazon.com/Oracle-Database-11g-SQL-Press/dp/0071498508/ref=sr_1_2?s=books&ie=UTF8&qid=1353562612&sr=1-2&keywords=oracle+sql

   

   

   

  • Marked as answer by Young Yang - MSFT on Dec 09, 2012 01:34 AM