Get student details from [B]tblDNFRec[/B] table whose joining month is "January".

Amatya
Posted by Amatya under Sql Server category on | Points: 40 | Views : 602
Get student details from tblDNFRec table whose joining month is "January".

Select * from tblDNFRec where SUBSTRING(convert(varchar,joining_date,100),1,3)='Jan'


Thanks
Amatya

Comments or Responses

Login to post response