Problem selecting random records

Hi everybody,

I have a little problem selecting random records from a MySQL database.

At the moment, my query looks like:
--- query ---
select seq, artist, credat, upddat from artists
order by rand() limit 10
--- /query ---
which selects a maximum of 10 random records from the database.

The problem is that I would like to have these records sorted by artist.
Coming from an Oracle background, I'd write it as follows:
--- query ---
select seq, artist, credat, upddat from
(
(insert original select)
)
order by artist
--- /query ---
but apparently this does not work. The error I receive is "1248: every
derived table must have its own alias".

What is the best/easiest way to solve this? As an emergency solution, I can
sort the details outside of the database in my program, but that is not a
good practice.

Thanks in advance,

Ikke

Ikke wrote:
> Hi everybody,
>
> I have a little problem selecting random records from a MySQL
> database.
>
> At the moment, my query looks like:
> --- query ---
> select seq, artist, credat, upddat from artists
> order by rand() limit 10
> --- /query ---
> which selects a maximum of 10 random records from the database.
>
> The problem is that I would like to have these records sorted by
> artist. Coming from an Oracle background, I'd write it as follows:
> --- query ---
> select seq, artist, credat, upddat from
> (
> (insert original select)
> )
> order by artist
> --- /query ---
> but apparently this does not work. The error I receive is "1248: every
> derived table must have its own alias".

Hmmz, I thought that would work.
If they say you need an alias, why not give it:
select z.seq, z.artist, z.credat, z.upddat from
(
(insert original select)
) as z
order by artist
--
Rik Wasmus

"Rik" <luiheidsgoeroe@hotmail.com> wrote in news:5eabf$4549dd97$8259c69c
$23695@news2.tudelft.nl:

<snip>
> Hmmz, I thought that would work.
> If they say you need an alias, why not give it:
> select z.seq, z.artist, z.credat, z.upddat from
> (
> (insert original select)
> ) as z
> order by artist

Thanks - I was trying to add the alias to the original select, which of
course failed miserably. Now I get it

Best regards,

Ikke