If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Counter In SQL

gerryjuice · 2006-11-01 14:45:14

Can some one please tell me how to display a random number of records from a database using SQL.

01-11-2006 2:45pm

#1

gerryjuice

Closed Accounts Posts: 73 ✭✭

Join Date: November 2004

Posts: 33

Can some one please tell me how to display a random number of records from a database using SQL.

0

Comments

#2 01-11-2006 2:57pm

TheWaterboy

Registered Users, Registered Users 2 Posts: 379 ✭✭

Join Date: February 2005

Posts: 331

do u mean something like this:

SELECT * FROM tbl_name ORDER BY RAND() LIMIT 15

0
#3 01-11-2006 3:41pm

bonkey

Registered Users, Registered Users 2 Posts: 15,443 ✭✭✭✭

Join Date: April 2001

Posts: 14635

Very much depends on which system you're using, but fundamentally you're gonna use a TOP, LIMIT, ROWNUM or whatever your DB offers against a RAND function of some description as just described.

Seems like an odd thing to want to do though.

jc

0
#4 01-11-2006 4:40pm

gerryjuice

Closed Accounts Posts: 73 ✭✭

Join Date: November 2004

Posts: 33

Just need to get a representation of the data within a table, so needed to get a random selection.
Thanks for the help.

0