Cum extrag toate account_id-urile care se regasesc in aceasta baza mai mult de N de ori?

Salut, am o baza de date cu o multime de tranzactii.  O sa incerc sa simplific structura bd.  Sa presupunem ca e un tabel unde sunt inregistrate toate tranzactiile  cu urmatoarele coloane:
account_id,  transaction_type, date , amount .
Cum as putea sa extrag din aceasta baza de date toate account_id-urile care se regasesc in aceasta baza mai mult de N de ori. ?
In exemplu de mai jos  contul cu id-ul 1119 se regaseste de 3 ori , cum as putea sa-l extrag.?

• account_id, transaction_type,    date ,    amount
  
• 1119 Deposit 15.10.2018 2500
  
• 1119 Deposit 15.10.2018 500
  
• 1119 Withdraw 17.10.2018 1500

Edited by marin-stefan, 26 October 2018 - 19:38.

SELECT account_id FROM table GROUP BY account_id HAVING COUNT(account_id)=3

Edited by neagu_laurentiu, 26 October 2018 - 19:42.

select account_id, count(account_id) from  [tabela ta] group by account_id  having count(account_id) > [valoarea N data de tine]

Edited by puiu_pe_diezel, 26 October 2018 - 19:48.

neagu_laurentiu, on 26 octombrie 2018 - 19:39, said:

Multumesc a mers .

select sa.securities_account_nbr, t.* from (select /*+ PARALLEL(16) */ aa.account_id,
			 count(*) from account_activity aa
			 where aa.trade_credit_amt > 1000 -- transfer $amt is greater than $1k
			 and aa.settlement_dt > TO_DATE('2018-01-20', 'YYYY-mm-DD')
			 and aa.account_activity_type_cd = 5
			 and aa.transfer_type_cd in ('9', '10', '11')
group by aa.account_id having count(*) > 300) t -- account has more than 300 transfers with above criteria
join securities_account sa on sa.account_id = t.account_id

Edited by marin-stefan, 26 October 2018 - 20:15.

marin-stefan, on 26 octombrie 2018 - 20:15, said:

doar sa ai grija cu inner join-ul ala, ca daca ai date pe criteriile alea si nu ai contul in securities_account_nbr, nu le vezi