ORDER BY limitations?

Results 1 to 2 of 2

Thread: ORDER BY limitations?

  1. #1
    Join Date
    Dec 1969

    Default ORDER BY limitations?

    What are the limitations of the Order by clause beyond ASC and DESC? i need to order 7 items which are out of alphabetical order ie order by <BR>P,L,G,G,P,P,R<BR>Beyond numbering these is there anything else I can do?

  2. #2
    Join Date
    Dec 1969

    Default What db

    if SQL Server, there&#039;s an article on this on SQLTeam.com. It involves the CASE function.

Posting Permissions

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