calculating age in sql

problem:finding the duplicate within sql solution:provide table named subscriber, with elements: email SELECT COUNT(DISTINCT email) AS NumberOfEmail, email FROM subscriber GROUP BY email HAVING (COUNT(email) > 1)

problem: displaying list of bday boy/girl in next (30/ according to your own choice ) days from the current date. solution: im using the sql to select the date of birth, for displaying, you can use whatever you want, like gridview, datalist etc. hereby the sql command: SELECT     DateOfBirth FROM         someTablename WHERE     (DateOfBirth < GETDATE())