Two random results

[orion_rus]

Hello world i have a database with wonders and want to show each loading page 2 random wonders from it.
Is it possible to make randoming in a sql level?
Thanks in advance

[emsaw]

orion_rus,

{found on goog}

look into newId() :

SELECT top 2 *
FROM mytable
ORDER BY newid()

HTH,

Mark

[Nutter]

SELECT field FROM table ORDER BY RAND() LIMIT 2