Q:

Get student details from tblStudent table whose admission year is “2015”.

0

Get student details from tblStudent table whose admission year is “2015”.

All Answers

need an explanation for this answer? contact us directly to get an explanation for this answer

Select * from tblStudent where SUBSTRING(convert(varchar,Admission_date,103),7,4)='2015'

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

Top 100 SQL server queries Interview questions

This question belongs to these collections

Similar questions


need a help?


find thousands of online teachers now
Get student details from tblStudent table whose ad... >>
<< Get first name, admission year, admission month an...