Programming

FIELD1               FIELD2                FIELD3
=========            ==============        ==============
3291234567           333991123456789       1234
3277654321           333011123456789       9876
3481234567           333101123456789       1234
3291234567           333991123456789       1234
3291234567           333011123456789       1234
3277654321           333015123456789       9876
3277654321           333103123456789       9876
3277654321           333201123456789       9876
3481234567           333112123456789       1234

FIELD1        FIELD2              FIELD3
=========     ==============      ============
3277654321    333011123456789     9876
3277654321    333015123456789     9876
3277654321    333103123456789     9876
3277654321    333201123456789     9876
3291234567    333991123456789     1234
3291234567    333991123456789     1234
3291234567    333011123456789     1234

     SELECT  A.FIELD1,  A.FIELD2 , A.FIELD3
        FROM 
        table A 
        INNER JOIN
        (
         SELECT FIELD1, COUNT (1) 
         FROM table
         GROUP BY FIELD1
         HAVING COUNT (1) >= 3
       ) AS B
       ON A.FIELD1 = B.FIELD1

       ) AS B
         *
ERROR at line 10:
ORA-00905: missing keyword

SQL> create table junk
  2     (field1  number,
  3      field2  number,
  4      field3  number )
  5  /

Table created.

SQL>
SQL> insert into junk values ( 3291234567, 333991123456789, 1234 );

1 row created.

SQL> insert into junk values ( 3277654321, 333011123456789, 9876 );

1 row created.

SQL> insert into junk values ( 3481234567, 333101123456789, 1234 );

1 row created.

SQL> insert into junk values ( 3291234567, 333991123456789, 1234 );

1 row created.

SQL> insert into junk values ( 3291234567, 333011123456789, 1234 );

1 row created.

SQL> insert into junk values ( 3277654321, 333015123456789, 9876 );

1 row created.

SQL> insert into junk values ( 3277654321, 333103123456789, 9876 );

1 row created.

SQL> insert into junk values ( 3277654321, 333201123456789, 9876 );

1 row created.

SQL> insert into junk values ( 3481234567, 333112123456789, 1234 );

1 row created.

SQL>
SQL> commit;

Commit complete.

SQL>
SQL> with w_grouped as (
      select field1, field2, field3,
             count(*) over (partition by field1) field1_cnt
        from junk A
      )
select field1, field2, field3
  from w_grouped
 where field1_cnt >= 3
/
  2    3    4    5    6    7    8    9
    FIELD1     FIELD2     FIELD3
---------- ---------- ----------
3277654321 3.3302E+14       9876
3277654321 3.3310E+14       9876
3277654321 3.3320E+14       9876
3277654321 3.3301E+14       9876
3291234567 3.3399E+14       1234
3291234567 3.3399E+14       1234
3291234567 3.3301E+14       1234

7 rows selected.

  from w_grouped
       *
ERROR at line 7:
ORA-01652: unable to extend temp segment by 640 in tablespace TEMP