Results 1 to 2 of 2

Thread: selecting randomly with SQL

  1. #1

    selecting randomly with SQL

    I'm looking for a bit of SQL code that will select some entries randomly from an SQL table.

    For instance I'd like to feed a parameter in that contains the number 20, and the returned record contains 20 randomly and distinct selected records.

    Anyone know how this can be done? (never came across randomly select records)

    any helps appreciated
    now with blog, click here

  2. #2
    http://www.petefreitag.com/item/466.cfm

    (also lots of info in the comments)

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Home About kirupa.com Meet the Moderators Advertise

 Link to Us

 Credits

Copyright 1999 - 2012