WITH maxDate AS (SELECT MAX(DataOrdine) AS MaxDataOrdine
           ,Ordine_UserID AS UserID
       FROM dbo.Ordine
         GROUP BY Ordine_UserID),
  orders AS ( SELECT OrdineID
        ,Ordine_UserID AS UserID
        ,DataOrdine
         FROM  dbo.Ordine ORD
       INNER JOIN maxDate
         ON ORD.Ordine_UserID = maxDate.UserID
        AND MaxDataOrdine = DataOrdine)
   
   SELECT OrdineID
       ,UserID
       ,DataOrdine
       FROM orders;