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

0 vote140 views1 answer
Min salary in sql
SQL
14 votes150 views3 answers
Oracle sql limit results
SQL
0 vote138 views1 answer
Search db for table name
SQL
1 vote121 views1 answer
Oracle sql assign unique number to each grouping
SQL
10 votes132 views6 answers
Mysql delete duplicates
SQL
1 vote168 views1 answer
Postgres select as csv
SQL
2 votes187 views2 answers
Mysql date range
SQL
3 votes124 views1 answer
Oracle nextval
SQL
0 vote179 views1 answer
Drop a view in sqlite
SQL
0 vote146 views1 answer
Install sql server windows 10
SQL