1. We have moved to a new forum! There may be a few things not working properly so please let us know if you find a bug. Remember to use the bbCode [ sql ] tag for SQL statements.
New XenForo forum! Google Ads

Select a row at random?

Discussion in 'SQL - Questions and Answers' started by ben, Apr 19, 2006.

  1. ben Administrator

    Dialect: ANY
    ben, Apr 19, 2006
    #1

  2. ben Administrator

    Dialect: MySQL
    SQL:

    
SELECT * FROM some_table ORDER BY RAND() LIMIT 1
    ben, Apr 19, 2006
    #2

  3. Josh Ross Guest

    Dialect: MS SQL
    SQL:
    SELECT top 1 word FROM dictionary ORDER BY rand(checksum(word + convert(varchar(23),getdate(),21)))
    Josh Ross, Apr 21, 2006
    #3

  4. alexfr New Member

    Dialect: Postgresql
    SQL:

    
SELECT column FROM table
    
ORDER BY RANDOM()
    
LIMIT 1
    alexfr, May 24, 2006
    #4

  5. Hank Swart Guest

    Dialect: MS SQL
    SQL:

    
SET ROWCOUNT 1
    

    
SELECT
    
	NEWID() AS [RANDOM],
    
	PROJECT,
    
	SITE_ID,
    
	SAMPLE_ID
    
FROM 
    
	GB_SAMPLE
    
ORDER BY
    
	[RANDOM] ASC
    

    
SET ROWCOUNT 0
    Hank Swart, Dec 18, 2006
    #5

  6. Hank Swart Guest

    Dialect: MS SQL
    SQL:

    
SELECT TOP 1
    
	NEWID() AS [RANDOM],
    
	PROJECT,
    
	SITE_ID,
    
	SAMPLE_ID
    
FROM 
    
	GB_SAMPLE
    
ORDER BY
    
	[RANDOM] ASC
    Hank Swart, Dec 18, 2006
    #6

  7. Eder Nucci Guest

    Dialect: MS SQL
    SQL:

    
Select * from YourTable Order By NewId()
    Eder Nucci, Feb 22, 2007
    #7

Share This Page