Total members 11889 |It is currently Thu Mar 28, 2024 5:29 pm Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka






For randomly selecting a record from database using RAND function , to get a one record randomly you can run the following query :

Code:

SELECT 
FROM Department where  type='active' ORDER BY RAND() limit 1


You can also select more records:

Code:

SELECT 
FROM Department where  type='active' ORDER BY RAND() limit 10




_________________
M. S. Rakha, Ph.D.
Queen's University
Canada


Author:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time
Post new topic Reply to topic  [ 1 post ] 

  Related Posts  to : selecting a record randomly from table
 Randomly generated rows and columns in Array     -  
 error in inserting record     -  
 Timeout error while updating record in SQLServer in ASP.NET     -  
 Selecting a Database in php     -  
 Selecting a Domain Name at the Time of Registration     -  
 Draw Bezier Curve and selecting the points with mouse click     -  
 table creation     -  
 row highlight of table     -  
 table row hover     -  
 Creating table using div tag     -  



cron






Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com