sanjay potdar
New User
Joined: 13 Sep 2011 Posts: 1 Location: india
|
|
|
|
Hi,
I am facing one issue. I have to write one query which will select only those records, which are having 2 words only in a particular column. I tried several join scenarios, but that didn't work.
Let take an eg.
Suppose i am having the following list.
Sunil
Sunil Kumar
Sunil Kumar Pandey
Sandeep
Sandeep Srivastava
Sanjay
Sanjay Potdar
Sanjay Pnadurang Potdar
So the result should be:
Sunil Kumar
Sandeep Srivastava
Sanjay Potdar
Please help me in writing that query. |
|