tsql - SQL Selecting Maximum Based on Minor-Major scheme -

i trying create query select distinct line, select using revision minor / major scheme. below example table:

serial number | revmajor | revminor ----------------------------------- aq155         |    1     |    1 aq155         |    1     |    2   aq155         |    1     |    1 aq155         |    1     |    7     aq155         |    2     |    1  <--------- jr2709        |    1     |    7 jr2709        |    2     |    2  <--------- 

how can write query in t-sql 2008 select 2 highlighted lines, "newest revision"?
in advance!

you could

select * (     select *, row_number() on (partition [serial number] order revmajor desc, revminor desc) versionrank     table ) t versionrank = 1