dgielis_

Archive · 21 December 2006

Testing pre-tag with Beta Blogger

Written 20 years ago. Oracle APEX has moved on a lot since; check the current Oracle APEX posts too.

A statement without the pre-tag:

SELECT t.team_name, t.team_id
FROM tdg_team t,
(SELECT r.team_id, rank() over (PARTITION BY r.team_group_id ORDER BY r.points DESC, r.matches_won DESC, r.goals_difference DESC, r.goals_scored DESC) team_rank
FROM tdg_match_rank r
WHERE r.tournament_id = :TDG_AI_TOURNAMENT_ID) rt
WHERE t.team_id = rt.team_id AND rt.team_rank IN (1,2)

A statement with the pre-tag:

SELECT t.team_name, t.team_idFROM tdg_team t,    (SELECT r.team_id, rank() over (PARTITION BY r.team_group_id                                    ORDER BY r.points DESC, r.matches_won DESC,                                    r.goals_difference DESC, r.goals_scored DESC) team_rank       FROM tdg_match_rank r      WHERE r.tournament_id = :TDG_AI_TOURNAMENT_ID) rtWHERE t.team_id = rt.team_id AND rt.team_rank IN (1,2)

Originally published on Blogspot.

Comments

Comments appear after I've read them. Plain text; line breaks are kept. Privacy