sql to find selective duplicate rows

From: Wonderinguy <wonderinguy_at_hotmail.com>
Date: 24 Jan 2002 11:50:15 -0800
Message-ID: <6950e82.0201241150.65aa2b00@posting.google.com>

Expert !

I have a table

NAMETAB

---

FIRST_NAME CHAR(20)
MID_NAME CHAR (20)
LAST_NAME CHAR(20)
....

...

I rows like

FIRST_NAME MID_NAME LAST_NAME

---

ANDY                 x               COLLINS
ANDY                 y               COLLINS
ROCHELLE             a               ROB
ROCHELLE             a               ROB
MIKE                 s               TYSON
GEORGE               D               CLOONEY
GEORGE               D               CLOONEY
ROBERT               H               HILLEN
ROBERT               J               HILLEN

....
....

I want to list rows with same FIRST_NAME and LAST_NAME but different MID_NAME eg:
  ANDY x COLLINS
  ANDY y COLLINS
  ROBERT H HILLEN
  ROBERT J HILLEN can anybody please provide me with the SQL to get this result set.

Thanks in advance.. Received on Thu Jan 24 2002 - 13:50:15 CST