duplicates

[raj123]

is there a way to pick the latest and greatest among the duplicates.This is a reference table so we will see multiple orderids


select orderid,product,orderdate from orders table;

1234 --abc--05-APR-2005 11:30:28
1234 -- abc --05-APR-2005 11:15:34

in the above is thier easer way i can pick the orderid based on latest orderdate.In the above i need to pick the following row
1234 --abc--05-APR-2005 11:30:28

Some times i have 10 + rows for every orderid.

please let me know

Thanks Raj

[gandolf989]

Originally posted by raj123
is there a way to pick the latest and greatest among the duplicates.This is a reference table so we will see multiple orderids


select orderid,product,orderdate from orders table;

1234 --abc--05-APR-2005 11:30:28
1234 -- abc --05-APR-2005 11:15:34

in the above is thier easer way i can pick the orderid based on latest orderdate.In the above i need to pick the following row
1234 --abc--05-APR-2005 11:30:28

Some times i have 10 + rows for every orderid.

please let me know

Thanks Raj

What about something like this?

SELECT orders_table.orderid, 
       orders_table.product,
       orders_table.orderdate 
  FROM orders_table
 INNER JOIN
     ( SELECT orderid, MAX(orderdate) orderdate
         FROM orders_table
        GROUP BY orderid ) ot
    ON ot.orderid    = orders_table.orderid   AND
       ot.orderdate  = orders_table.orderdate;

btw why do you have so many duplicates?

[raj123]

hi ,
thanks for the help .will try

i have one other coulmn in the same table , where the customer can do update then it goes to different stage

also this table has one other unique row