nested / join

Question

nested / join

naravetlasri

Newbie

Points: 1
More actions
March 29, 2012 at 8:13 am

#259214

Hi,
I am new to this SQL,and I am practicing some online examples where I got stuck with one of the excercise .
here is the Question
In which years was the Physics prize awarded but no Chemistry prize.
Can any one help me with this.
Table NOBEL (yr,subject,winner)
2008 Physics A
2008 Physics B
2008 Physics C
2008 Chemistry D
2008 Chemistry E
2008 medicine F
2008 medicine G
2008 medicine H
2008 economics I
2008 econmics J

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

This exact issue is the topic of today's spackle article by Jeff Moden. http://www.sqlservercentral.com/articles/T-SQL/88244/[/url]

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

CapnHector SSCoach Points: 16143 More actions · Answer 2

naravetlasri (3/29/2012)
Hi,
I am new to this SQL,and I am practicing some online examples where I got stuck with one of the excercise .
here is the Question
In which years was the Physics prize awarded but no Chemistry prize.
Can any one help me with this.
Table NOBEL (yr,subject,winner)
2008 Physics A
2008 Physics B
2008 Physics C
2008 Chemistry D
2008 Chemistry E
2008 medicine F
2008 medicine G
2008 medicine H
2008 economics I
2008 econmics J

i recognize that problem, sqlzoo.com. and also read the same article posted above. that is the way to solve this problem.

PS: might go through sqlzoo again.

For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]