Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle SQL problem... Newbie question
Hi all,
I have a problem with the 'order by' clause in SQL. I have a query like
select
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
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
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 - 09:43:02 CDT