I'm having trouble with this select statement I need help with.
date1 order_no p_amt
8/11/06 123 800
3/27/07 123 800
3/28/06 123 800
9/11/07 123 0
I want the output of min date with p_amt <=0.
When a select statement I get the output of 3/27/07, it ignores the p_amt
column . any suggestions.
thanks in advance.
On Jun 6, 12:39 pm, ITDUDE27 <ITDUD
You want the minimum value of date1 from those rows where p_amt is
less than or equal to zero.
SELECT min(date1) FROM tbl WHERE p_amt <= 0
See? It almost writes itself.