Home 2018 May SQL Puzzle: Find the upcoming Birthday for a Next Month

SQL Puzzle: Find the upcoming Birthday for a Next Month

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

Check the below input data and expected output for finding the upcoming birthdays of students.

Input Data:

Expected Output for May 2018:

Create a table:

Solution:

Please try the different solution for this puzzle and share it via comment...

Anvesh Patel
SQL Server: Using xp_cmdshell, Read the data of Text FileSQL Puzzle: Get the list of Monday of a Month
Comments: 6
  1. Dinesh
    May 4, 2018 at 1:08 pm

    –Methos-1
    Select * From TBL_Employee
    Where Convert(Date,Replace(Convert(VarChar,DOB),Year(DOB),Year(GetDate())))
    Between Convert(Date,GetDate()) And Convert(Date,GetDate()+30)

    –Method-2
    Select * From TBL_Employee
    Where Convert(Date,Convert(VarChar(4),Year(GetDate()))+Right(DOB,6)) Between Convert(Date,GetDate()) And Convert(Date,GetDate()+30)

    –Method-3
    Select * From TBL_Employee
    Where Convert(Date,Convert(VarChar(4),Year(GetDate()))+’/’+Cast(Month(DOB) As VarChar(2))+’/’+Cast(Day(DOB) As VarChar(2))) Between Convert(Date,GetDate()) And Convert(Date,GetDate()+30)

    ReplyCancel
  2. aravind
    May 4, 2018 at 5:42 pm

    select *,current_date from employees where extract(‘month’ from dob)>=extract(‘month’ from current_date::date) order by dob desc limit 1;

    ReplyCancel
  3. karthik
    November 1, 2018 at 2:55 pm

    select EmpName ,DOB from tbl_Employee where datename(MONTH , DOB) = datename(MONTH , DATEADD( MONTH,1, getdate()))

    ReplyCancel
  4. Dpan
    April 15, 2019 at 9:41 am

    ;with BDay as (
    select Empid,EmpName,DOb,DateDiff(dd,GETDATE(),stuff(Dob,1,4,2019)) as UpcomingDate from #tbl_employee
    )
    select Top 1 * from BDay where UpcomingDate>0 Order by UpcomingDate

    ReplyCancel
  5. HIC
    April 27, 2019 at 6:03 pm

    select e1.*
    from
    tbl_Employee e1
    where e1.dob = (
    select min(e.dob)
    from
    tbl_Employee e
    where
    add_months(e.dob, (EXTRACT(year FROM sysdate) – EXTRACT(year FROM e.dob)) * 12) >= sysdate
    );

    ReplyCancel
  6. Hareesh
    January 6, 2020 at 4:57 pm

    select * from tbl_Employee
    where MONTH(DOB) = MONTH(Getdate())+1

    ReplyCancel

Leave a Reply

CAPTCHA

*

Anvesh Patel
Anvesh Patel

Database Engineer

May 3, 2018 6 Comments SQL Puzzle, , , , , , , , , ,