locked
select max(date) GROUP BY SEQ NO in oracle RRS feed

  • Question

  • User-1075092149 posted

    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.

    Monday, November 19, 2012 2:57 AM

Answers

All replies

  • User269602965 posted

    Oracle Analytics using windowing functionality

    Monday, November 19, 2012 3:07 PM
  • User-1075092149 posted

    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.

    Tuesday, November 20, 2012 2:12 AM
  • User269602965 posted

    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 Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, November 22, 2012 12:38 AM