Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Get two random records of each state in a table
- Thread starter Swi
- Start date
- Thread starter
- #3
If you want an answer you have to put some effort into writing a question. I can think about 10 ways to do this but I got no idea what the output is.
Is it a list of 100 items ( 2 of each state) in a random order? You could simply "Select RND(ID) as SortOrder, strState from tblStates as A UNION ALL Select Rnd(ID) as SortOrder, strState from tblStates as B;"
Are you doing a recordset draw in code and feeding a variable?
Is it a list of 100 items ( 2 of each state) in a random order? You could simply "Select RND(ID) as SortOrder, strState from tblStates as A UNION ALL Select Rnd(ID) as SortOrder, strState from tblStates as B;"
Are you doing a recordset draw in code and feeding a variable?
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
