| From: | <bmccoy(at)chapelperilous(dot)net> |
|---|---|
| To: | abe <abe(at)fish(dot)tm> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: ORDERING alphabetically |
| Date: | 2000-08-09 17:31:53 |
| Message-ID: | Pine.LNX.4.10.10008091330050.25494-100000@chapelperilous.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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;
Brett W. McCoy
http://www.chapelperilous.net/~bmccoy/
-------------------------------------------------------------------------------
But soft you, the fair Ophelia:
Ope not thy ponderous and marble jaws,
But get thee to a nunnery -- go!
-- Mark "The Bard" Twain
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Philip Hallstrom | 2000-08-09 17:54:53 | How to create an index using a function??? |
| Previous Message | abe | 2000-08-09 17:15:14 | ORDERING alphabetically |