SQL - DodgeIntrepid.Net Forums - Dodge Intrepid, Concorde, 300m and Eagle Vision chat
 
LinkBack Thread Tools Rate Thread Display Modes
post #1 of 7 (permalink) Old 12-01-2001, 04:35 PM Thread Starter
 
Join Date: Jun 2001
Posts: 145
Feedback: 0 / 0%
 
SQL

im in the middle of a test and i need some help. does anybody know how to alphabetize your results from a sql query? ASAP PLEASE!!
what the code ORDER by { } ____?
bvwib is offline  
Sponsored Links
Advertisement
 
post #2 of 7 (permalink) Old 12-01-2001, 04:39 PM
 
Join Date: Sep 2001
Posts: 8,099
Feedback: 0 / 0%
               
I believe it's just:

ORDER BY "the field you want ordered"
IntrepidXJ is offline  
post #3 of 7 (permalink) Old 12-01-2001, 04:43 PM Thread Starter
 
Join Date: Jun 2001
Posts: 145
Feedback: 0 / 0%
 
i want to order the results in this case the last names from the query in alpha order, order by lname ____?
bvwib is offline  
Sponsored Links
Advertisement
 
post #4 of 7 (permalink) Old 12-01-2001, 04:44 PM
 
Join Date: Sep 2001
Posts: 8,099
Feedback: 0 / 0%
               
Just looked it up:

By default, the ORDER BY phrase causes the database to sort in an ascending fashion: A to Z for string values, and 0 to infinity for numeric values.
IntrepidXJ is offline  
post #5 of 7 (permalink) Old 12-01-2001, 04:46 PM
 
Join Date: Sep 2001
Posts: 8,099
Feedback: 0 / 0%
               
Shoud just be:

ORDER BY lname

That will organize by last name in ascending order.
IntrepidXJ is offline  
post #6 of 7 (permalink) Old 12-01-2001, 05:18 PM
Intrepid Pro
 
Join Date: Jun 2001
Posts: 3,574
Feedback: 0 / 0%
                     
Moved to computer section.
TehKing is offline  
post #7 of 7 (permalink) Old 12-01-2001, 05:30 PM
Si
 
Join Date: Jul 2001
Posts: 1,061
Feedback: 0 / 0%
 
Hey LHSer, is that your kid in your Imagine sig? Cute kid..

Si
Si is offline  
Sponsored Links
Advertisement
 
Reply

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the DodgeIntrepid.Net Forums - Dodge Intrepid, Concorde, 300m and Eagle Vision chat forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

Member names may only be composed of alpha-numeric characters. (A-Z and 0-9)

!!ATTENTION ADVERTISERS!! If you intend on advertising anything on this forum, whatsoever, you are required to first contact us here . Additionaly, we do NOT allow BUSINESS NAMES unless you are an Authorized Vendor. If you own a business, and want to do sales on this site via posting or private message, you will need to follow the rules. Shops, Stores, Distributors, Group Buys without being authorized will see your account terminated.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes Rate This Thread
Linear Mode Linear Mode
Rate This Thread:



Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome