select * from student where ((TestType = '1sem' and @sem='1sem') or (TestType = '2sem' and @sem='2sem' ) or ((TestType in ('1sem','2sem') and @sem='dual' ))
Hope it Helps!!
No comments:
Post a Comment