On Sun, Feb 01, 2004 at 06:22:30PM +0100, Tomasz Myrta wrote:
> Dnia 2004-02-01 14:34, U¿ytkownik Michael Fuhr napisa³:
> > SELECT *
> > FROM records
> > ORDER BY lastName,
> > firstName,
> > SUBSTRING(term FROM 1 FOR 4),
> > CASE SUBSTRING(term FROM 5)
> >WHE
Dnia 2004-02-01 14:34, Użytkownik Michael Fuhr napisał:
Consider storing the session in a separate field and assigning each
session a value that collates in the order you want.
Here's a way to order the sessions using their current format:
SELECT *
FROM records
ORDER BY lastName,
firstNam
> I need a little help on a sorting problem. Imagine a table, call it
> records, that has fields:
>
> lastName
> firstName
> term
>
> I want to sort the records by last name, then first name, and finally by
> term. This almost does what I want:
>
> select * from records order by lastName, firstN
All,
I need a little help on a sorting problem. Imagine a table, call it
records, that has fields:
lastName
firstName
term
I want to sort the records by last name, then first name, and finally by
term. This almost does what I want:
select * from records order by lastName, firstName, term;
Howe
