Can rownum return invalid data when referenced 2x in a query

I am creating a simple table with 3 columns (first name, last name and id columns). I need to return each distinct id in the table, along with a single name associated with the id (it doesn't matter which name I get back, as long as I get back a val...

Read More...

---