SQL problem with Order by

From: Unmesh <unmeshl_at_aol.com>
Date: Mon, 25 Oct 1999 10:44:16 -0400
Message-ID: <38146CBF.B901FCFE_at_aol.com>

Hi all,
[Quoted] I have a problem with the 'order by' clause in SQL. I have a query like

select

[Quoted] AWD.ITEM_TYPE,
AWD.EMPLID,
AWD.INSTITUTION
FROM    PS_STDNT_AWARDS AWD,
        PS_ITEM_TYPE_FA ITF
WHERE   AWD.EMPLID = 'XXXXX'
  AND   AWD.INSTITUTION = 'YYYYY'
  AND   AWD.AID_YEAR = '2000'
  AND ((AWD.AWARD_PERIOD = 'A') OR (AWD.AWARD_PERIOD = 'B'))
  AND ((AWD.AWARD_STATUS = 'A') OR (AWD.AWARD_STATUS = 'O'))
  AND   ITF.PRINT_LTR_OPTION <> 'N'
  AND   ITF.SETID = AWD.SETID

  AND ITF.AID_YEAR = '2000'
  AND ITF.ITEM_TYPE = AWD.ITEM_TYPE
   and itf.item_type in ('60', '30', '45', '90', '46')   AND ITF.EFFDT = (SELECT MAX(EFFDT)

                     FROM PS_ITEM_TYPE_FA ITF1
                    WHERE ITF1.SETID = ITF.SETID
                      AND ITF1.AID_YEAR = ITF.AID_YEAR
                      AND ITF1.ITEM_TYPE = ITF.ITEM_TYPE
                      AND ITF1.EFF_STATUS = 'A'
                      AND ITF1.EFFDT <= sysdate)

ORDER BY ITF.ITEM_TYPE where I want the output to come in a particular order of item types. Like
60, 30, 45, 90, 46.

i.e. I want to produce the output according to a particular order in a list of values. Which is the way to do this? Any feedback is appreciated.

Thanks,
Unmesh Received on Mon Oct 25 1999 - 16:44:16 CEST