How to make double Order by???

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default How to make double Order by???

    I'm beginner with cold fusion...if someone could help me...

    From a table with two fields City and Country I want to obtain an
    interrogation with two ordering: first ordered Country and then City. Can I
    make it in one query?

    An example shoud be:

    COUNTRY CITY
    America Chicago
    America New York
    France Paris
    Italia Milano
    Italia Modena
    Italia Roma

    Thank you a lot!
    bye


    bimbica Guest

  2. Similar Questions and Discussions

    1. Tab Order always greyed out, need to redefine order but can't
      I had a check box but then i had to delete it and change it to a text field. now my tab order is all out of whack and I can't seem to set the tab...
    2. Datagrid - Make columns match XML order
      It seems there are lots of topics close to this, but none with answers. I have attempted to complete the Dinner Menu sample example in Flash 8. I...
    3. Double Clicking and Changing Order in Portal Rows
      Oops, I submitted the question below the night before last. If there were any responses, they were deleted before I could catch them. The moderator...
    4. You must have Ncurses installed in order to use 'make menuconfig'
      On Thu, Jun 26, 2003 at 09:27:54AM -0400, nori heikkinen wrote: 'make menuconfig' is part of the Linux kernel. libncurses5-dev is...
    5. You must have Ncurses installed in order to use 'make menuconfig'
      On Thu, 26 Jun 2003 09:27:54 -0400 nori heikkinen <nori@sccs.swarthmore.edu> wrote: Probably because menuconfig works for every Linux...
  3. #2

    Default Re: How to make double Order by???

    order by country, city
    Dan Bracuk Guest

  4. #3

    Default Re: How to make double Order by???

    Ok thank you I'll try to do so. But I've thought another way to do it, with group by country and order by city. If I want more than two ordered columns, will it work?
    bimbica Guest

  5. #4

    Default Re: How to make double Order by???

    :)
    It works with more than two fields: for example ORDER BY Country, Language, City...and so on.


    bimbica Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139