using distinct in a single column to get multiple rows

I need to get a unique column but I also need to return multiple rows.

Using the following doesn't work to get the unique last name since it gets all unique columns.

select unique userid, title, address
from myTable
where etc.........
order by userid

The userid will be returned multiple times because the other columns cause the row to be unique.

How do I get a unique userid while still returning the other rows.

Thanks!
Dave Received on Mon Sep 19 2011 - 10:38:54 CDT