I am trying to select information from a table based on how many times it is repeated within the same table.
Below is a summary of the select statements I know this wont work but I hope it gives an idea of what I am trying to achieve
select
id_client
from gl_booking
where count(id_client) > 2
Do I need to to a sub select or is there a realy easy way around this.
I do hope this makes sense
Thank you in advance