On Sat, 01 Jun 2002 11:58:38 +0200
Claire Forchheimer [EMAIL PROTECTED] wrote:
I know the answer to the first part at least. I think you want to use two columns in
the order by clause, and leave out the group by clause. As in:
select * from tbl order by apt, name;
I'm afraid its too late at
Hi all,
I have a table including two colums: names and apartment numbers:
apt #| name
--
1 | Smith Joe
1 | Smith Anne
2 | Doe Richard
3 | Svensen Mike
3 | Brant Liza
I need to get a list in alphabetical order, but with people in the same
apt keept together:
Brant,