last but one row

[PAVB]

SELECT *
FROM 
(
SELECT  order_id, 
        ordered_date,
        RANK() OVER (PARTITION BY ORDER_ID ORDER BY ordered_date DESC,orderrevision DESC) ORANK
FROM    orders 
)
WHERE orank = 2
;
select *
from   orders 
order by order_id DESC,ordered_date DESC,orderrevision DESC
;  
		
ORDER_ID	ORDERED_DATE	            ORANK
55761	    03/11/2005 12:00:00.000 AM	2
55762	    03/13/2005 12:00:00.000 AM	2
55763	    03/16/2005 12:00:00.000 AM	2
		
ORDER_ID	ORDERED_DATE	            ORDERREVISION
55763	    03/17/2005 12:00:00.000 AM	4
55763	    03/16/2005 12:00:00.000 AM	3
55763	    03/15/2005 12:00:00.000 AM	2
55763	    03/15/2005 12:00:00.000 AM	1
55762	    03/14/2005 12:00:00.000 AM	3
55762	    03/13/2005 12:00:00.000 AM	2
55762	    03/12/2005 12:00:00.000 AM	1
55761	    03/12/2005 12:00:00.000 AM	3
55761	    03/11/2005 12:00:00.000 AM	2
55761	    03/10/2005 12:00:00.000 AM	1