...

View Full Version : Selecting from A-Z



bubbles19518
09-21-2006, 04:29 AM
I have a query:
"SELECT * FROM table"

and I want to select if alphabetically, I've seen the code somewhere but cant remember it, can anyone help me out?

Fumigator
09-21-2006, 06:15 AM
SELECT *
FROM table
ORDER BY column_name

bubbles19518
09-21-2006, 02:30 PM
And what if I want to go from Z-A?

NancyJ
09-21-2006, 02:43 PM
SELECT *
FROM table
ORDER BY column_name DESC



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum