these are the follwing questions I have:
1) give the name of the student who has grades for only two columns
this relates to a table called 'grade' , which has 6 columns - std_code, gr_name, gr_t1, gr_t2, gr_pr,gr_hw.
I need to select a student who has grades for only two out of these four colums --gr_t1, gr_t2, gr_pr,gr_hw.
Can someone suggest any solution?
1) give the name of the student who has grades for only two columns
this relates to a table called 'grade' , which has 6 columns - std_code, gr_name, gr_t1, gr_t2, gr_pr,gr_hw.
I need to select a student who has grades for only two out of these four colums --gr_t1, gr_t2, gr_pr,gr_hw.
Can someone suggest any solution?