Help me !

minhtri · August 1st, 2004, 12:15 AM

Could you tell me how to Select random a SQL statement from VB 6.0

madhukp · August 1st, 2004, 11:25 PM

I am sorry, but I could not understand your requirement. Could you please explain it in details ? What do you mean by "Select random a SQL statement" ?

marcostraf · August 2nd, 2004, 12:11 PM

get the number of records, and generate a random number using rnd:

lRecordToRead = fix(rnd * lTotalRecords)

then move to lRecordToRead

Marco

Jeff Mason · August 2nd, 2004, 04:13 PM

Do you want to select a random row from an SQL Query?

If so, and you are using SQL Server, try:

Code:

SELECT TOP 1 yourcolumn1, yourcolumn2, ...
FROM yourtable
ORDER BY NEWID();

The NEWID() function generates a GUID for each row in your query. Guids are random, unique values, so ordering the results of your query by this random number and then selecting just one row gives you one random row from the entire query.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com