Sql select upcoming birthdays

SELECT 
  BRTHDATE AS BIRTHDAY
 ,FLOOR(DATEDIFF(dd,EMP.BRTHDATE,GETDATE()) / 365.25) AS AGE_NOW
 ,FLOOR(DATEDIFF(dd,EMP.BRTHDATE,GETDATE()+7) / 365.25) AS AGE_ONE_WEEK_FROM_NOW
FROM 
  "Database name".dbo.EMPLOYEES EMP
WHERE 1 = (FLOOR(DATEDIFF(dd,EMP.BRTHDATE,GETDATE()+7) / 365.25))
          -
          (FLOOR(DATEDIFF(dd,EMP.BRTHDATE,GETDATE()) / 365.25))

Source: stackoverflow.com

Similar codes

5 votes174 views2 answers
Update all rows mysql
SQL
1 vote177 views1 answer
Pv mysql import
SQL
0 vote179 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
2 votes192 views1 answer
How to delete columns in sql
SQL
0 vote161 views1 answer
Suse start MySQL
SQL
0 vote226 views1 answer
Insert into using contant values and source table columns with sql
SQL
2 votes139 views1 answer
Sql view column data type
SQL
0 vote173 views1 answer
Sql create text column limited values
SQL
0 vote164 views1 answer
How to connect to mysql in ef 6
SQL
0 vote189 views1 answer
Get last date join sql
SQL