SQL query related to Date.

[Limno]

1.query to find out all employee IDs whose birthday fall today ?

2.query to find out 10th specific record?

Thank u,
Limno.

[gpl]

@Limno
Not only does this sound like homework, you havent transcribed the question completely. What does 10th specific record mean ?

A clue to the birthday issue - the DatePart function can retrieve the day part of a date and also the month part of the date, so your Where clause would need to do something like

Where month part of birthday = month part of today
and day part of birthday = day part of today

The year is of course irrelevant, as birthdays occur every year, except for the special case of leap days.

The Books Online help for SQL server is very good

[ammoos]

1.
SELECT Emp_ID, BirthDate
FROM Table1
Where
datepart(day,BirthDate)=datepart(day,GETDATE())
AND
datepart(month,BirthDate)=datepart(month,GETDATE() )
ORDER BY Emp_ID

2.
select top 1 Emp_ID, BirthDate from
(
SELECT top 10 Emp_ID, BirthDate
FROM Table1
Where
datepart(day,BirthDate )=datepart(day,GETDATE())
AND
datepart(month,BirthDate )=datepart(month,GETDATE())
ORDER BY Emp_ID
) tempTable
ORDER BY Emp_ID desc