How to get the minimum date of same column in DB2

Question

Need to get order qty of the minimum ADATE

Im using below query and getting 12 records. Now I want to select orderqty of minimum ADATE which is 06-NOV-2018(2018-11-06). For every customer(will get multiple records), i need to get the Order_Qty of minimum ADATE column.

select
   Customer ,
   OrderID ,
   LocationID ,   
   Order_Qty,Sent_date ,ADATE
   from
   (
      select
      OrderID ,
      LocationID ,
      Sent_date ,
      Order_Qty ,
      Customer ,
      TimeStampA
      from ARC_TBL
   )
   obn
   inner join
   (
      select
      ADATE ,TimeStampA
      from trackTBL snt
   )snt
   on obn.TimeStampA = snt.TimeStampA
    where Customer='ABC' and OrderID='XYZ100' and Sent_date='2018-11-18' and LocationID='250';

Possible duplicate of [Select first row in each GROUP BY group?](https://stackoverflow.com/questions/3800551/select-first-row-in-each-group-by-group) — Clockwork-Muse, Dec 07 '18 at 00:48

score 0 · Answer 1 · answered Dec 06 '18 at 20:00

0

SELECT QTY, ADATE
  FROM table
 ORDER BY ADATE 
 FETCH FIRST 1 ROW ONLY

Explain your question in more detail and you will get better answers.

answered Dec 06 '18 at 20:00

MichaelTiefenbacher

3,805
2
11
17

For every customer(will get multiple records), i need to get the Order_Qty of minimum ADATE column. select Customer,OrderID,LocationID,Order_Qty,Sent_date,ADATE from (select OrderID, LocationID,Sent_date,Order_Qty,Customer,TimeStampA from ARC_TBL) obn inner join( select ADATE ,TimeStampA from trackTBL snt )snt on obn.TimeStampA = snt.TimeStampA where Customer='ABC' and OrderID='XYZ100' and Sent_date='2018-11-18' and LocationID='250'; – Jitendra SR Dec 06 '18 at 20:21

How to get the minimum date of same column in DB2

1 Answers1