Posts Tagged ‘random’

Random in SQL – SQL For Programmers

IMG_1382 Last week I had an interesting assignment: Given a specific record, randomly retrieve three related records from the database.

Naturally, as a programmer, I started looking for the SQL random function.  Which I found.

But even as I was searching for how to use that function, I was thinking to myself, “How am I going to structure things in such a way so as to randomly select the records once I have the function?  It isn’t like I can retrieve the records into an array and then select them out.  Am I going to have to retrieve them into a temp table?”

Read the rest of this entry »

Other Related Items:

Chessex Dice: Ten Sided Dice - D10 - Random Group of Ten Sided Die (You Pick How Many You Want)Chessex Dice: Ten Sided Dice - D10 - Random Group of Ten Sided Die (You Pick How Many You Want)This is random selected d10 dice lots .... 6, 10, 20 die lots ... We will select a random colors and styles from Chessex's vast inventory
Gore Bike Wear Women's Contest Lady Tights ShortGore Bike Wear Women's Contest Lady Tights ShortDont feel like you need to be a competitive cyclist to make good use of the Gore Bike Wear Womens Contest Cycling Short. Specific to women's physique,... Read More >
DotNetNuke Sponsor

 

Most Valuable Blogger
Sponsor