[عبدالله الدوسري]

هكذا سأكتب الكود :
   

كود :

    SELECT T1.*
    FROM table_1 AS T1
    WHERE T1.update_no = (
                          SELECT TOP 1 T2.update_no
                          FROM table_1 AS T2
                          WHERE (T2.code = T1.code)
                          order by T2.update_no DESC
                          )