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
mysql
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