var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Retrieving random records
I did a few searches before posting but could not find an answer.
Does anyone know the SQL (if any) to retrieve 10 random records from a table? This is pretty easy in MS SQL Server but I cannot find a solution for Sybase.
Thank you very much.
select top 10 id, name
,r=(select rand() from sysobjects b where b.id=a.id)
from sysobjects a
where name like 'sys%'
order by r