Advanced Search

Return to Snippet

Revision: 11046
at January 21, 2009 16:37 by jordantbro
Initial Code 
SELECT column, RAND() as IDX  
FROM table  
ORDER BY IDX FETCH FIRST 1 ROWS ONLY
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Selecting a Random Row In IBM DB2

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL