need help on my query.

Posted by Dharmendra on Stack Overflow See other posts from Stack Overflow or by Dharmendra
Published on 2010-05-06T05:49:56Z Indexed on 2010/05/06 5:58 UTC
Read the original article Hit count: 244

Filed under:

i have one table : nobel(yr, subject, winner)

and i have this query : In which years was the Physics prize awarded but no Chemistry prize.

this is what i tried : select distinct yr from nobel where subject='physics' and subject!='chemistry'

but is not working where i am going wrong.

see, i am not here to make my homework from someone. i am here to learn something. so, please give me suggetion.

© Stack Overflow or respective owner

Related posts about mysql