Solve my Query!!

Hello , can anybody solve my prob's

Below is the table detail

select * from ST_Mas_IncentiveFac


Inc_Code Inc_Date Division_Code Ass_Target
---------- ----------- ---------- -----------
1 2003-02-09 1 76.0
2 2003-09-22 1 87.0
3 2003-09-02 2 86.0
4 2003-09-23 3 78.0
5 2003-09-02 1 87.0
6 2003-09-02 1 87.0
7 2003-09-02 1 87.0
8 2003-09-02 2 88.0
10 2003-09-02 3 99.0
11 2003-09-02 3 99.0

(10 row(s) affected)


Query
******
select MIF2.Inc_Code,MIF2.Division_Code,MIF2.Inc_Date,MIF 2.Ass_Target FROM ST_Mas_IncentiveFac MIF2,
(SELECT MIF1.Division_Code,MAX(MIF1.Inc_Date) as IncDate from ST_Mas_IncentiveFac MIF1
group by MIF1.Division_Code)ns1
WHERE MIF2.Division_Code=ns1.Division_Code
AND MIF2.Inc_Date =ns1.IncDate
order by MIF2.Division_Code,MIF2.Inc_Code desc

Result
******

Inc_Code Division_Code Inc_Date Ass_Target
---------- ----------------- ------------- --------------
2 1 2003-09-22 87.0
8 2 2003-09-02 88.0
3 2 2003-09-02 86.0
4 3 2003-09-23 78.0

(4 row(s) affected)


My Requirement is

I need only the Inc_Code's of 2,8,4 and not the 3 of the Division_Code

In your where clause add these two lines

select * from ST_Mas_IncentiveFac


Inc_Code Inc_Date Division_Code Ass_Target
---------- ----------- ------------- -----------
1 2003-02-09 1 76.0
2 2003-09-22 1 87.0
3 2003-09-02 2 86.0
4 2003-09-23 3 78.0
5 2003-09-02 1 87.0
6 2003-09-02 1 87.0
7 2003-09-02 1 87.0
8 2003-09-02 2 88.0
10 2003-09-02 3 99.0
11 2003-09-02 3 99.0

(10 row(s) affected)


Query
******
select MIF2.Inc_Code,MIF2.Division_Code,MIF2.Inc_Date,MIF 2.Ass_Target FROM ST_Mas_IncentiveFac MIF2,
(SELECT MIF1.Division_Code,MAX(MIF1.Inc_Date) as IncDate from ST_Mas_IncentiveFac MIF1
group by MIF1.Division_Code)ns1
WHERE MIF2.Division_Code=ns1.Division_Code
AND MIF2.Inc_Date =ns1.IncDate
order by MIF2.Division_Code,MIF2.Inc_Code desc

Result
******

Inc_Code Division_Code Inc_Date Ass_Target
---------- ------------- ----------- ----------
2 1 2003-09-22 87.0
8 2 2003-09-02 88.0
3 2 2003-09-02 86.0
4 3 2003-09-23 78.0

(4 row(s) affected)


My Requirement is

I want to display the max date of distinct division codes.
Here I had two entries for the same date for a division i.e eg for 2 nd division.
In that i have to filter the record on
the basis of max Inc Code of that particular division no (eg 2nd division).