i have this table:
Players:
ID (int)
Birthday (datetime)
I need choose 3 first players, which have birthday in the actual month... I have this but the result is nothing.. Have you any idea?
SELECT *
FROM Players
WHERE Birthday < DATEADD(month, -2, GETDATE())
Using SQL Server syntax:
select top 3 *
from YourTable
where datepart(month, Birthday) = datepart(month, getdate())