random selection

Results 1 to 2 of 2

Thread: random selection

  1. #1
    Join Date
    Dec 1969

    Default random selection

    Guys,<BR>I have this SQL statement running against a SQL Server 2000 DB that looks like this: <BR><BR>SELECT DISTINCT Email AS ContestWinner<BR>FROM tblContestant<BR>WHERE (ContestName = &#039;March 1000&#039;) <BR><BR>How can I radomize this so that it only picks one winner and that winner being random?

  2. #2
    Join Date
    Dec 1969

    Default Look up RAND in the BOL

    Very good tutorials on useing

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts