I have this table `columns_tab`:

```
INDEX_OWNER     INDEX_NAME           TEXT
------------------------------------------------------------------------
DUMMY           PK_FUL_REQUEST       CUSTOMERID, ID, INSTITUTIONID
NIR             PK_FUL_REQUEST       CUSTOMERID, ID, INSTITUTIONID
NIR             IX_REQUEST_HASH      CUSTOMERID, HASH_KEY, INSTITUTIONID
DUMMY           UQ_REQUEST_HASH      CUSTOMERID, HASH_KEY, INSTITUTIONID

```

I want to get the row where the text column is equal but the index\_name is not equal.

I can do it with 2 same tables, but can I do it with one table?

Expected result is:

```
    INDEX_OWNER     INDEX_NAME           TEXT
------------------------------------------------------------------------
NIR             IX_REQUEST_HASH      CUSTOMERID, HASH_KEY, INSTITUTIONID
DUMMY           UQ_REQUEST_HASH      CUSTOMERID, HASH_KEY, INSTITUTIONID

```

The query for it can be achieved by

```
select index_owner, index_name, text
  from columns_tab a, columns_tab b
 where a.text = b.text
   and a.index_name != b.index_name

```

I want to achieve it without select twice from the same table.