sql - How to group only particular row of table -

sql - How to group only particular row of table -

i have table userid, username column like:

username userid sakthi 50 sakthi 50 sakthi 50 sakthi 50 ganesh 40 ganesh 40 ganesh 40

i want grouping count(userid)>3

i want grouping record like:

username userid sakthi 50 ganesh 40 ganesh 40 ganesh 40

you need break select statement 2 parts , union all them together.

something (obviously alter data):

select username, userid tbl grouping username, userid having count(*) > 3 union select username, userid tbl userid not in ( select userid tbl grouping username, userid having count(*) > 3 )

example sqlfiddle...

sql