Posted By

pauliehaha on 02/09/09


Tagged


Versions (?)

select random example


 / Published in: SQL
 

  1. -- Select at Random
  2. SELECT c.Answer, u.username, p.Name, p.Surname, p.City, p.Town, p.PostCode FROM mbfTools_Competitor c
  3. JOIN MBF_DB_1.dbo.aspnet_Profile p
  4. ON c.UserId = p.UserId
  5. JOIN MBF_DB_1.dbo.aspnet_Users u
  6. ON c.UserId = u.UserId
  7. WHERE c.competitionid = 172
  8. AND c.answer LIKE '%As little as three minutes%'
  9. ORDER BY NEWID()

Report this snippet  

You need to login to post a comment.