Selecting a random record from table [message #292256] |
Tue, 08 January 2008 05:18  |
javon
Messages: 7 Registered: December 2007
|
Junior Member |
|
|
Hi.
Can anybody tell me what should be the SQL to select a random record from a table?
Of course, this should be generic enough to be applied on any table.
Thanks in adavnce.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: Selecting a random record from table [message #423536 is a reply to message #423519] |
Fri, 25 September 2009 02:56  |
pablolee
Messages: 2882 Registered: May 2007 Location: Scotland
|
Senior Member |
|
|
*Sigh*
1. Why post Non-Oracle syntax? This is an Oracle site, our answers are based on that.
2. This thread is nearly 2 years old, you haven't really added anything (and in fact you have used the same Oracle 'solution' as has been posted twice already in the thread, so why even bother?
Beaten to it (21 Months by my reckoning JRowbottom )
[Updated on: Fri, 25 September 2009 02:57] Report message to a moderator
|
|
|