query problem

On Fri, Mar 23, 2001 at 02:21:24PM -0000, Gyan wrote:

Greetings! Kindly lemme know how do u sort a table on some
field...please talk about the command that does it. Thanx.

the sorting is done in the select command (see the docs under
'SELECT' for more detail):

select p.fullname,e.salary,d.name as dept,d.supervisor
from person p,employee e,department d
where p.id=e.id and dept.id=e.dept
ORDER BY dept,fullname

--
It is always hazardous to ask "Why?" in science, but it is often
interesting to do so just the same.
-- Isaac Asimov, 'The Genetic Code'

will@serensoft.com
http://newbieDoc.sourceforge.net/ -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

On Fri, 23 Mar 2001, Gyan wrote:

Greetings!
Kindly lemme know how do u sort a table on some field...please talk about the command that does it.
Thanx.
Gyan Ranjan

using the ORDER BY clause in a query. eg
SELECT col1,col2,col3 FROM tablename ORDER BY col1;
You can get info on how to use sql from the postgresql documentation
(http://www.postgresql.org), but best would be if you'd just read a
book about sql.

- Einar Karttunen