title: random select from table
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/19412/how-to-request-a-random-row-in-sql">How to request a random row in SQL?</a>  </p>
  </blockquote>
  
  
  
  <pre><code>           I have table:
             name,age,school
             jane,15,zu
             peter,16,zu
             john,15,stu
             Tomas,15,kul
             viera,17,stu
             tibor15,zu
  </code></pre>
  
  <p>I want select from this table 1 person (randomly) per school</p>