Forum

Share:

Notifications

Clear all

How to Write a SQL Query to get all people whose birth year is the same (2019,2020 e.t.c)

Last Post

RSS

<img alt='' src='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=80&r=g&d=mm' srcset='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=80&r=g&d=mm 2x' class='avatar avatar-80 photo' height='80' width='80' decoding='async'/>

Posts: 47

Pavan NJ

Guest

Topic starter

Jul 28, 2020 6:55 am

(@Pavan NJ)

Eminent Member

Joined: 3 years ago

Any year like 2019 or 2020.

I want to capture all people whose birth yer is the same from a table. Consider employee table.

Topic Tags

sqlbirthyearsame

1 Reply

<img alt='' src='//www.gravatar.com/avatar/145acdc57a7ca44c99fa14d88bdddeb8?s=80&r=g&d=mm' srcset='//www.gravatar.com/avatar/145acdc57a7ca44c99fa14d88bdddeb8?s=80&r=g&d=mm 2x' class='avatar avatar-80 photo' height='80' width='80' decoding='async'/>

Posts: 36

Sandeep0069

Guest

Jul 28, 2020 11:01 am

(@Sandeep0069)

Eminent Member

Joined: 3 years ago

I choose in 2019 . You can also use In List to get both the year's data.

Select Name, DateOfBirth, CAST(DateOfBirth as Date) as [DatePart]

From Employees

where Year(DateOfBirth)='2019'

Reply

Leave a reply

Share:

Forum Statistics

10 Forums

174 Topics

321 Posts

0 Online

1,386 Members

Latest Post: Query Optimization: A Comprehensive Guide for Stored Procedures Our newest member: anjalirrb Recent Posts Unread Posts Tags

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo version 2.2.2