Order By Statement - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

vb89 · 09-22-2008, 06:08 PM

I have the following SQL statement

Code:

 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

jugalboro · 11-04-2008, 10:59 AM

Logical Database
--------------------
|Player_name| player_position |
--------------------------------------------------------------
|----- Mr. D -----|---------- 1----------|
|----- Mr. S -----|---------- 4----------|
|----- Mr. R -----|---------- 2----------|
|----- Mr. N -----|---------- 3----------|
--------------------------------------------------------------

1= Forward
2= Defense
3= Goalie
4= Center
-----------------------------------------------------------
ORDER BY player_position ASC/DESC
-----------------------------------------------------------