Query using Max value

[snufse]

In the query below I need to be able to retrieve the max value for bm.revision_number within each bm.movement_number ie I just need one record for each bm.movement_number. Not sure how to use MAX. Thank you.

SELECT	distinct(bm.movement_number), MAX(bm.revision_number) OVER (PARTITION BY bm.movement_number) Max_Revision_Number, bm.movement_date, bm.batch_voyage_number,
		bm.reference_number, bm.type, bm.status, bm.bulk_movement_id, bp.terminal_product_number,
		bp.terminal_product_number, bp.supplier_number, bp.tank_code, bp.gross_quantity, 
		bp.net_quantity, tp.product_group_code, tp.name, tp.petroex_product_code, 
		sp.petroex_company_code
FROM		[VEMO-FACS1].FUELFACS.dbo.bulk_movement AS bm
INNER JOIN	[VEMO-FACS1].FUELFACS.dbo.bulk_product AS bp ON bp.bulk_movement_id = bm.bulk_movement_id  
INNER JOIN	[VEMO-FACS1].FUELFACS.dbo.terminal_product AS tp ON tp.terminal_product_number = bp.terminal_product_number
INNER JOIN	[VEMO-FACS1].FUELFACS.dbo.supplier AS sp ON sp.supplier_number = bp.supplier_number
group by    bm.movement_number, bm.revision_number,
            bm.movement_date, bm.batch_voyage_number,
            bm.reference_number, bm.type, bm.status, bm.bulk_movement_id, bp.terminal_product_number,
            bp.terminal_product_number, bp.supplier_number, bp.tank_code, bp.gross_quantity, 
            bp.net_quantity, tp.product_group_code, tp.name, tp.petroex_product_code, 
            sp.petroex_company_code

The result I get is (movement_number, revision_number)

1 4
1 4
1 4
1 4
1 4


The content of the table is

movement_number, revision_number
1 0
1 1
1 2
1 3
1 4

I this case I just need record with revision_number = 4