Gossamer Forum
Home : General : Databases and SQL :

sql querie i am having problem with

Quote Reply
sql querie i am having problem with
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?