DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2001


    In EMP table when I execute the syntax
    Select * from emp where ename in('king','Allen','Blair','Tony')
    it gives the output in the same sequence of names as stored in table e.g first allen,tony,king and then blair. But I require the output in the same sequence same as in query as king,allen,blair and then tony.
    In Oracle I can do it by Decode function but in SQL server there is no DECODE function.
    Please help

    [Edited by arun_rashmi on 04-21-2001 at 04:00 AM]

  2. #2
    Join Date
    Jul 2000
    Question is asked and answered before:

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.