holemania
asked on
SQL Query - Where Clause Question
I have a table that I am querying some tables from and wanting to pull the last date. However, sometimes this date is the same. Example, a PO that was last received on the same day for same Item.
How could I create my query that if the "Received_Date" is the same, then look at the "Want_Date" instead?
select item_id, Unit_price, Want_date, Received_date
from PO_Line
Not sure how to tweak the above query that if "Received_Date" is the same, then look at "Want_date" and only pull the most recent. Any ideas?
How could I create my query that if the "Received_Date" is the same, then look at the "Want_Date" instead?
select item_id, Unit_price, Want_date, Received_date
from PO_Line
Not sure how to tweak the above query that if "Received_Date" is the same, then look at "Want_date" and only pull the most recent. Any ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Leon,
I'll look at what Scott suggested, but I am pulling some data off a table. Sometimes, the "received date" is the same, and I want to pull the most recent "received date". Since I can have 2 or more records received on same date, then I am told to use the "want date" as the next filter.
The example above, I have 2 PO that was received on the same date. Now I need to then look at the "want date".
I'll look at what Scott suggested, but I am pulling some data off a table. Sometimes, the "received date" is the same, and I want to pull the most recent "received date". Since I can have 2 or more records received on same date, then I am told to use the "want date" as the next filter.
The example above, I have 2 PO that was received on the same date. Now I need to then look at the "want date".
ASKER
Thank you. That worked.
Could just be that it is late, but could you clarify the question please, I am having rouble understanding what you want the query to accomplish.
if "Received_Date" is the same, then look at "Want_Date".
(If the Received_Date colum is identical to the Want_Date, or if there are multiple records returned for the item ID for that date?)
Cheers
Leon