To find the earliest dated record

  • Thread starter Thread starter rama
  • Start date Start date
R

rama

Hello,
I have a table which is having few fields “Date”, “Material”, “PO”.
This table is for maintaining the material purchasing details. My
problem is same material is purchased with different PO in different
dates. I wanted to find out earliest dated PO’s of all material from
this table. I am putting some sample data here for your consideration.

Material PO Date
10192 600012 10/20/2009
10192 600009 10/6/2009
10192 600003 9/6/2009
20292 600020 10/30/2009
20292 600004 9/4/2009
20293 600013 10/30/2009

I would like to have the query result as follows

Material PO Date
10192 600003 9/6/2009
20292 600004 9/4/2009
20293 600013 10/30/2009

Thanks
Rama
 
hi Rama,
I have a table which is having few fields “Date”, “Material”, “PO”.
This table is for maintaining the material purchasing details. My
problem is same material is purchased with different PO in different
dates. I wanted to find out earliest dated PO’s of all material from
this table. I am putting some sample data here for your consideration.
Click to expand...
Use something like this:

SELECT O.*
FROM [yourTable] O
WHERE O.[Date] =
(
SELECT MIN(I.[Date])
FROM [yourTable] I
WHERE I.[Material] = O.[Material]
)


mfG
--> stefan <--
 
hi Rama,
I have a table which is having few fields “Date”, “Material”, “PO”.
This table is for maintaining the material purchasing details. My
problem is same material is purchased with different PO in different
dates. I wanted to find out earliest dated PO’s of all material from
this table. I am putting some sample data here for your consideration.
Click to expand...

Use something like this:

SELECT O.*
FROM [yourTable] O
WHERE O.[Date] =
(
   SELECT MIN(I.[Date])
   FROM [yourTable] I
   WHERE I.[Material] = O.[Material]
)

mfG
--> stefan <--
Click to expand...

Hello,
Thank you very much for the support.
Rama
 
Back
Top