Two Records Of Same Partner Together

Hi all,

Here is the table and DML statments
CREATE TABLE [jatpartnerMst] (
[rowid] [int] ,
[partnerid] [int] NULL ,
[mcstat] [int] DEFAULT (1), -- 1 Pending ,2 Approved
[sf] [varchar] (20)
)

INSERT INTO [jatpartnerMst]
([rowid],[partnerid],[mcstat],[sf])VALUES(1,1,2,'active')
INSERT INTO [jatpartnerMst]
([rowid],[partnerid],[mcstat],[sf])VALUES(2,1,2,'active')
INSERT INTO [jatpartnerMst]
([rowid],[partnerid],[mcstat],[sf])VALUES(3,1,2,'active')
INSERT INTO [jatpartnerMst]
([rowid],[partnerid],[mcstat],[sf])VALUES(4,1,2,'active')
INSERT INTO [jatpartnerMst]
([rowid],[partnerid],[mcstat],[sf])VALUES(5,1,1,'active')
INSERT INTO [jatpartnerMst]
([rowid],[partnerid],[mcstat],[sf])VALUES(6,1,2,'inactive')
INSERT INTO [jatpartnerMst]
([rowid],[partnerid],[mcstat],[sf])VALUES(7,1,2,'inactive')
INSERT INTO [jatpartnerMst]
([rowid],[partnerid],[mcstat],[sf])VALUES(8,1,2,'inactive')
INSERT INTO [jatpartnerMst]
([rowid],[partnerid],[mcstat],[sf])VALUES(9,2,2,'active')
INSERT INTO [jatpartnerMst]
([rowid],[partnerid],[mcstat],[sf])VALUES(10,2,1,'active')
INSERT INTO [jatpartnerMst]
([rowid],[partnerid],[mcstat],[sf])VALUES(11,1,2,'active')

What I wish to find is the latest record on the top and it's other
records
e.g If partnerID 1 is changed it goes to the bottom of the table , at
any given time I am interested only in max(rowid) for a partner with
stat 1 or 2

I am using this query
select * from jatpartnerMst where rowid in (select max(rowid) from
jatpartnermst where mcstat in (1,2) group by partnerid,mcstat )


This query does not give me the latest.

On using this query
select * from jatpartnerMst where rowid in (select max(rowid) from
jatpartnermst where mcstat in (1,2) group by partnerid,mcstat )
order by rowid desc

The partner's two records get seperated . I wish to show them following
one another.
So the output should be

1112active
511active
922active
1021active

11 & 5 rowids are following each other because they are rows of same
partner and 11 is the most recent row [ because new rows are inserted
at the end]

Is it possible to do the above using single query
I am using cursor to do the same.

With Warm regards
Jatinder