Ordering an SQL statement

Results 1 to 2 of 2

Thread: Ordering an SQL statement

  1. #1
    Join Date
    Dec 1969

    Default Ordering an SQL statement

    I have a database with the following format:<BR><BR>Table name: URL_Extensions<BR>Columns:<BR>Username: e.g. dave2<BR>URL_extension: e.g. algarve090900.shtml<BR>page name: e.g. Algarve 09/09/00<BR><BR>All the above are &#039varchar&#039.<BR><BR>I have the following SQL statement:<BR><BR>extText="select page_name, URL_extension from URL_extensions where username = &#039"&p_username&"&#039"<BR><BR>The problem I have is that I want to order the output chronologicaly by page name (so Algrave 09/05/00 does not come before Algarve 09/03/00).<BR><BR>Is this possible?<BR><BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Ordering an SQL statement

    &nbsp;<BR>Order By UserName Asc

Posting Permissions

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