944,018 Members | Top Members by Rank

Ad:
Apr 24th, 2007
0

Assignment Help Plz!! Urgent

Expand Post »
hey all
i need to find the birds with the largest number of habitats.
attached is the database i am working with.

i sort of need the solution in about 2hrs time....

thanx ali
Attached Files
File Type: zip BirdsSql.ZIP (24.4 KB, 8 views)
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
ali_rulz is offline Offline
3 posts
since Apr 2007
Apr 24th, 2007
0

Re: Assignment Help Plz!! Urgent

sorry i forgot to add that i am using winsql and need the query.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
ali_rulz is offline Offline
3 posts
since Apr 2007
Apr 24th, 2007
0

Re: Assignment Help Plz!! Urgent

Did you write your own query yet? If not, try it and post it here if you are having problems. Otherwise, do your own homework. We're here to help, not do your work for you.
Moderator
Reputation Points: 161
Solved Threads: 38
He's No Good To Me Dead
stymiee is offline Offline
1,422 posts
since May 2006
Apr 24th, 2007
0

Re: Assignment Help Plz!! Urgent

yeh i have written my own code but not even sure if on right track...
Select H.HCode, Count (*)
From Birds B, Habitats H, Bird_Habitats BH
Where B.BirdID = BH.BirdID
Group By H.HCode, B.BirdID
Having Count (*) >= some (Select Count (*)
From Bird_Habitats
Group By BirdID);

and just for the record i wasnt trying to get u to do my homework for me i was purely trying to get help in understanding how to write this particular query!
thanx ali
Reputation Points: 10
Solved Threads: 0
Newbie Poster
ali_rulz is offline Offline
3 posts
since Apr 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Database Design Forum Timeline: Database assignment help
Next Thread in Database Design Forum Timeline: Database Design feedback (absolute beginner here :)





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC