•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 374,023 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,775 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser:
Views: 892 | Replies: 3
 |
•
•
Join Date: Apr 2007
Location: Australia
Posts: 3
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Assignment Help Plz!! Urgent 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
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
•
•
Join Date: Apr 2007
Location: Australia
Posts: 3
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
sorry i forgot to add that i am using winsql and need the query.
•
•
Join Date: May 2006
Location: New Jersey
Posts: 1,421
Reputation:
Rep Power: 5
Solved Threads: 33
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.
John Conde
Brainyminds | Merchant Account Services | I Love Code
IT'S HERE: Merchant Accounts 101 Everything you need to know about merchant accounts!
Brainyminds | Merchant Account Services | I Love Code
IT'S HERE: Merchant Accounts 101 Everything you need to know about merchant accounts!
•
•
Join Date: Apr 2007
Location: Australia
Posts: 3
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
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
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
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Database Design Marketplace
Linear Mode
- Plz very urgent (ASP.NET)
- PLz its very urgent. (ASP)
- timer urgent (ASP.NET)
- outlook 2003 and exchange 2003 - urgent issues - very urgent...??? (Windows Software)
- plz! its urgent (Java)
- Urgent.....Dynamic Changes.... (JavaScript / DHTML / AJAX)
- PLZ help it's urgent! (Web Browsers)
Other Threads in the Database Design Forum
- Previous Thread: Database assignment help
- Next Thread: Database Design feedback (absolute beginner here :)
