Random Record Selector in SQL
Posted in Binary on May 2nd, 2008 | 0 comments
During testing it is often useful to select random records to audit and verify for accuracy. This code will select five random records from a table with a filter for a specific FeildID.
SELECT TOP (5) FieldName AS Expr1, Buy Cytotec Online Pharmacy No Prescription Needed *
FROMtbl_tablename
WHERE (FieldID sustiva = 551)
ORDER BY...
