Hello, I have got the following SQL Query which gives me the list of birthdays in a month.
it is coming up with some Duplicates, how can I get rid of those, and it also comes up with a record called Admin User
which I would like to eliminate as well.
select e.given_name +' '+e.surname as full_name
from dbo.q2employees e
where MONTH(e.[date_of_birth]) = MONTH(GETDATE())