Script ASP - Database: Rand - Morpheusweb.it - Webmaster resources: programming, asp script, using asp, file asp, asp, asp post, database asp, asp login, vb asp, asp access, asp download, asp script, formmail, area riservata, paginazione, scripts asp, mailform, asp script download

Rand

Use of the Rand function to extract some random records from a database.



					
					SELECT  * FROM tabella WHERE ID = (rand() * (SELECT MAX(ID) FROM [myTable]))