16-02-2021, 03:45 PM
أكبر تاريخ
كود :
SELECT a.id, a.date1, a.salary
FROM Table1 a
INNER JOIN (
SELECT id, MAX(date1) date2
FROM Table1
GROUP BY id
) b ON a.id = b.id AND a.date1 = b.date2
أكبر أجر
كود :
SELECT a.id, a.date1, a.salary
FROM Table1 a
INNER JOIN (
SELECT id, MAX(salary) salary1
FROM Table1
GROUP BY id
) b ON a.id = b.id AND a.salary = b.salary1
رَبَّنَا اغْفِرْ لِي وَلِوَالِدَيَّ وَلِلْمُؤْمِنِينَ يَوْمَ يَقُومُ الْحِسَابُ


![[-]](https://delphi4arab.net/forum/D4A2020/collapse.png)