SQL RANK() function Example

   SELECT p.version, p.launch_date
   RANK() OVER (PARTITION BY p.version
   ORDER BY p.launch_date DESC) "Rank"
   FROM product p WHERE p.id = '1234'