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