Select everything, based on distinct USER ID in Oracle

Question

I am trying to select * from an oracle table, but only where user_id are unique.

i tried this:

select distinct user_id from users; -- which worked

i want to display EVERYTHING, so when i put:

select distinct user_id, * from users; -- i get a syntax error

how can i accomplish his?

Answer 1

select distinct user_id, users.* from users; 

Answer 2

select * from users where users.primary_key IN 
  (select primary_key FROM users GROUP BY user_id HAVING count(*) = 1)

This will only select records that do not share user_ids with other rows.