English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

Tournaments

Date
Names
Scores
Venue
Winner

Consists of many

Matches

Date
Names
Scores

Many Matches consist of many

Scores

Date
Names
Server
Serve
Return
In/Out
Winning point
Area
Distance
Contact

2007-03-01 05:08:39 · 3 answers · asked by Conor 1 in Computers & Internet Programming & Design

3 answers

You have NAMES is all 3 tables. Is that TournamentName, MatchName, TeamName, or PlayerName?

Same thing with DATE

You need a MatchID field to link the One tourney to Many Matches by the Matches Table primary key

SCORES should probably link to Matches but not to Tournaments, and you need a ScoresID to link

I don't see how Area, Distance, or Contact have anything to do with Scores, though I don't know what game this is for.

I would think a 4th table called Statistics might be appropriate for some of the data in the Scores table

2007-03-01 05:23:40 · answer #1 · answered by rod 6 · 2 0

My query looks something like this:

SELECT DISTINCT a, b, c FROM aTable WHERE rownum <= 1000

but it returns 987 records because of the distinct, how to really get a 1000 records, I don't want to do this:

SELECT * FROM (
SELECT DISTINCT a, b, c FROM aTable
)
WHERE rownum <= 1000

since the performance would be horrible!

2007-03-07 22:00:51 · answer #2 · answered by Lord Jimothy 1 · 0 0

Don't worry; I totally know exactly and completely what you are trying to say. Go to your local clinic......and.....ask for......a burger.

2007-03-01 05:16:50 · answer #3 · answered by kalas j 2 · 0 5

fedest.com, questions and answers