title: How can I select 2 different random rows from a table?
body: <p>right now I have </p>
  
  <pre><code>row=session.query(Item).order_by(func.random()).limit(2)
  name1=row[0].name
  name2=row[1].name
  </code></pre>
  
  <p>Which gives me the first column(name) of each entry. The problem is, I get multiples (it will select the same random row twice. I want it to always be different. Is there a way to do this without an if, then statement?</p>
  
  <p>if its useful, when I print row, it gives me something like this: </p>
  
  <pre><code>SELECT items.id AS items_id, items.name AS items_name, items.data AS items_data FROM items ORDER BY random() LIMIT ? OFFSET ?
  </code></pre>
  
  <p>why would it say limit ? I have put in limit(2)</p>