SQL-finding duplicate row in table

The querry is

select userid from table group by userid having (count(*)>1) or
select userid from table group by userid having (count(userid)>1)