[ezahir]

(22-03-15, 12:59 AM)ameerah كتب : من فضلك، إذا كنت تعرف اللغة العربية، اكتب السؤال باللغة العربية
Se il vous plaît, si vous connaissez la langue arabe, tapez une question en arabe
(la traduction de Google)


(MsAccess)
M. X // entre 20 et 30 ans

كود :

SELECT *, DateDiff('yyyy', [date naissance], Date()) AS [âge]
FROM [personnes]
WHERE DateDiff('yyyy', [date naissance], Date()) BETWEEN 20 AND 30
ORDER BY DateDiff('yyyy', [date naissance], Date())

(MsAccess)
Mme Y // > ou = 31 ans

كود :

SELECT *, DateDiff('yyyy', [date naissance], Date()) AS [âge]
FROM [personnes]
WHERE DateDiff('yyyy', [date naissance], Date()) >= 31
ORDER BY DateDiff('yyyy', [date naissance], Date())

(SQL Server)
M. X // entre 20 et 30 ans

كود :

SELECT *, DateDiff(Year, [date naissance], GETDATE()) AS [âge]
FROM [personnes]
WHERE DateDiff(Year, [date naissance], GETDATE()) BETWEEN 20 AND 30
ORDER BY DateDiff(Year, [date naissance], GETDATE())

(SQL Server)
Mme Y // > ou = 31 ans

كود :

SELECT *, DateDiff(Year, [date naissance], GETDATE()) AS [âge]
FROM [personnes]
WHERE DateDiff(Year, [date naissance], GETDATE()) >= 31
ORDER BY DateDiff(Year, [date naissance], GETDATE())

السلام عليكم

أنا محتاج مسعدة لو سمحت
أنا شغال في برنامج إدارة شؤون الموظفين
عاوز أحسب السن