mardi 24 mai 2016

Count Function and IF Condition in (SQL)

select Count(Student_ID) as 'StudentCount' from CourseSemOne where Student_ID =1; i want to add only two values for this ID(Student_ID=1)..if Admin adding more than two values for this ID..then i want to show me a message "Sorry! you cannot add more than two values".

Aucun commentaire:

Enregistrer un commentaire