http://www.sfgate.com/cgi-bin/object/article?f=/c/a/2012/03/03/BUIO1NFAMI.DTL&object=%2Fc%2Fpictures%2F2012%2F03%2F02%2Fbu-brogrammer03__SFC0104118088.jpg
Thursday, May 31, 2012
Tuesday, May 29, 2012
Monday, May 28, 2012
How choose random records in database by SQL
MS SQL Server:
SELECT TOP 1 Field1, ..., FieldN
FROM Table1
ORDER BY NEWID()
Do not use:
SELECT TOP 1 Field1, ..., FieldN
FROM Table1
ORDER BY RAND()
MS Access:
SELECT TOP 1 Field1 , ..., FieldN
FROM Table1
ORDER BY Rnd(Field1)
Reference:
http://www.carlj.ca/2007/12/16/selecting-random-records-with-sql/
SELECT TOP 1 Field1, ..., FieldN
FROM Table1
ORDER BY NEWID()
Do not use:
SELECT TOP 1 Field1, ..., FieldN
FROM Table1
ORDER BY RAND()
MS Access:
SELECT TOP 1 Field1 , ..., FieldN
FROM Table1
ORDER BY Rnd(Field1)
Reference:
http://www.carlj.ca/2007/12/16/selecting-random-records-with-sql/
Subscribe to:
Posts (Atom)