Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 how to find this????

Author  Topic 

raja.narina
Starting Member

6 Posts

Posted - 2011-01-07 : 06:25:57
Retrieve all the data from Employeemaster table whose dateofbirth falls on the month jan orApril .

N.S.Sitaram

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2011-01-07 : 07:23:43
select * from Employeemaster where month(dateofbirth) = 1 or month(dateofbirth) = 4


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -