Ok, can i do this? I mean i want to order by name first, then i want to
orderby city, so if we have kevin and john in seattle, i want to be able to
sort them accordingly.
So is it possible to do two order by commands within the SQL statement?
-kev
yes, it is.
SELECT blahblah
...
ORDER BY city, name
Chris Olive,
DOEHRS Website Administrator
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 24, 2000 4:01 PM
To: [EMAIL PROTECTED]
Subject: Question about Multiple Order By
Ok, can i do
Order By Name, City
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 24, 2000 4:00 PM
Subject: Question about Multiple Order By
: Ok, can i do this? I mean i want to order by name first, then i want to
: orderby city, so if we have kevin and john
ORDER BY field1, field2, field3, etc.
Todd Ashworth
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 24, 2000 4:00 PM
Subject: Question about Multiple Order By
| Ok, can i do this? I mean i want to order by name first, then i want to
| orderby
The syntax would be
ORDER BY Name, City
Jeff Zubeck
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 24, 2000 1:00 PM
Subject: Question about Multiple Order By
Ok, can i do this? I mean i want to order by name first, then i want to
orderby city
You can do the order by clause as follows;
ORDER BY name, city
At 04:00 PM 7/24/00 EDT, you wrote:
Ok, can i do this? I mean i want to order by name first, then i want to
orderby city, so if we have kevin and john in seattle, i want to be able to
sort them accordingly.
So is it possible
oh my gosh, DUH! Thanks a bunch man.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message
7 matches
Mail list logo