jess Posted December 9, 2007 Share Posted December 9, 2007 hi i'm creating a hoilday database in oracle apex and i need to write a query in sql that shows which hoilday visits the most sites. i'm having alot of trouble with this can anyone help me?thanks jessica Link to comment Share on other sites More sharing options...
MrAdam Posted December 10, 2007 Share Posted December 10, 2007 Little too vague. Whats the database structure like? And what do you mean by "visits the most sites"?Adam Link to comment Share on other sites More sharing options...
jess Posted December 10, 2007 Author Share Posted December 10, 2007 hiwell the database has 5 tables:details of hoilday tabledifficulty ratings tablefull details of sitessites visisted on each hoildaydeparture datesthe query i need to do shows the code of each hoilday and each site and i need to show which hoilday code has the most sites attached to it.thanks jessica Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.