On Wed, 9 Aug 2000, abe wrote:
> Does anyone know how to get results from a query in alphabetical order
> (for one field such as surname). I skimmed over the documentation and
> no luck.
Use the ORDER BY clause in your query:
SELECT surname, firstname FROM names ORDER BY surname;
Bret
SELECT * FROM table ORDER BY table;
that seems to do the trick for me when I need to order things alphabeticly.
Mike
- Original Message -
From: "abe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 09, 2000 10:15 AM
Subject: [GENERAL] ORDERING
Hi there,
Does anyone know how to get results from a query in alphabetical order (for one
field such as surname). I skimmed over the documentation and no luck.
The field type for surname is varchar - Maybe this is why order by didn't work.
Thankyou,
Abe
