Order by Statement

[vb89]

I have the following SQL statement

 CURSOR player_cursor IS
    select *
    from customer_data.cd_soccer_players p
    where p.team_id = tID
    and p.league_id = p_leagueID
    and p.status = 'Y';

I would like to order the following statement by a column called player_position. Player position has four different options: goalie, forward, center, defense. I would like to have the player be ordered in the following order:
1. Forward
2. Defense
3. Goalie
4. Center

Any help would be greatly appreciated

 

[RyanEK]

Hi,

Try

select *, case 
  when player_position = 'Forward' then 1
  when player_position = 'Defense' then 2	
  when player_position = 'Goalie' then 3
  when player_position = 'Center' then 4  
  end as rank
from customer_data.cd_soccer_players p
where p.team_id = tID
and p.league_id = p_leagueID
and p.status = 'Y'
order by rank asc

Ryan

 

[vb89]

when i try to run the statement, is says that 'FROM' is not found where expected

 

[RyanEK]

Actually, looking at your cursor definition are you working off an Oracle db?