d2jsp
Log InRegister
d2jsp Forums > Off-Topic > Computers & IT > Programming & Development > 1000fg For Basic Sql Help
Add Reply New Topic New Poll
Member
Posts: 2,708
Joined: Aug 15 2008
Gold: 7,052.00
Oct 5 2014 01:48am
Im in an introductory database design business course and seeking help on one assignment

10 questions DDL and DML, done on oracle
one example question is.

Which locations did each player in the TEAMXXX play in February 20XX? Please list player name and location name and address. Sort by player last name and first name ascending.

Very simple.. I will send over the questions and can send fg upfront if youre trustworthy. otherwise ill send half after 5questions

I know i need to learn this myself but ive been too caught up in other stuff and no time to catch up at the moment
Member
Posts: 24,488
Joined: Jul 11 2011
Gold: 1,272.50
Oct 5 2014 02:03am
Well, i don't have enough information for your first clause of the question. Last part is easy though:

Code
ORDER BY lastname, firstname ASC


Member
Posts: 2,708
Joined: Aug 15 2008
Gold: 7,052.00
Oct 5 2014 01:05pm
Quote (HighschoolTurd @ Oct 5 2014 12:03am)
Well, i don't have enough information for your first clause of the question. Last part is easy though:

Code
ORDER BY lastname, firstname ASC


there will be initial DDL codes to start off.
Member
Posts: 1,901
Joined: Jul 30 2014
Gold: 0.00
Oct 6 2014 02:32am
SELECT name, location, address FROM (tablename) ORDER BY lastname, firstname ASC
Member
Posts: 2,708
Joined: Aug 15 2008
Gold: 7,052.00
Oct 6 2014 03:57pm
still looking for help, i have all the databases, all i need is DML for 10questions, to retrieve queries through oracle

should take an experienced person like 20mins at max
Member
Posts: 1,995
Joined: Jun 28 2006
Gold: 7.41
Oct 6 2014 04:05pm
Quote (mangostyle @ Oct 6 2014 04:57pm)
still looking for help, i have all the databases, all i need is DML for 10questions,  to retrieve queries through oracle

should take an experienced person like 20mins at max


You'd be surprised.

What are the questions?

Edit: Too late. I'm going to sleep, maybe later.

This post was edited by Minkomonster on Oct 6 2014 04:14pm
Member
Posts: 1,358
Joined: Dec 30 2012
Gold: 0.10
Oct 6 2014 04:16pm
pm me your questions
Member
Posts: 2,708
Joined: Aug 15 2008
Gold: 7,052.00
Oct 6 2014 08:04pm
Quote (SelfTaught @ Oct 6 2014 02:16pm)
pm me your questions


Still ISO, there are only 8 tables in the database
Go Back To Programming & Development Topic List
Add Reply New Topic New Poll