Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. fredinand

    Table with "starting date" for data

    Well, i think i have it. It was easier than i thought. select a.player_id, a.team_id, a.starting_date, min(b.starting_date) from player_team a left outer join player_team b on a.player_id = b.player_id and b.starting_date > a.starting_date group by a.player_id, a.team_id, a.starting_date order...
  2. fredinand

    Table with "starting date" for data

    Hi all. Suppose we have a table PLAYER_TEAM which stores the team (TEAM_ID) a player (PLAYER_ID) plays for, starting from a given date (STARTING_DATE). So we have something like this: PLAYER_ID TEAM_ID STARTING_DATE --------- ------- ------------- 1 1 20/10/2008...

Part and Inventory Search

Back
Top