How to find similar (but different) names with the same soundex value?

Question

enter image description here I want to select the soundex value S225 for the two names

This is what iried using this query but am not getting the exact result.

I got the output with the same name and same soundex value, but I want the result which has similar name and same soundex value.

Can anyone help me to do this?

Please give some examples that you'd like to find. How similar is similar? — dezso, Jul 9, 2015 at 11:06
And please do not post SQL statements as screen shots. Show the statements as formatted text. — user1822, Jul 9, 2015 at 11:14

user1822user1822 · Accepted Answer · 2015-07-09 11:15:50Z

2

You can use a window function for this:

select *
from (
   select name, 
          count(*) over (partition by soundex(name)) as cnt
   from poi
) t
where cnt > 1;

answered Jul 9, 2015 at 11:15

user1822

It Works...................... Thank u so much ...a_horse_with_no_name. then, what does the variable 't' stands for in that query?
– Mohamed Ashraf Ali B
Jul 9, 2015 at 11:46
1

@MohamedAshrafAliB it's not a variable but a mandatory table alias for a subquery.
– dezso
Jul 9, 2015 at 11:59
@a_horse_with_no_name
– Mohamed Ashraf Ali B
Jul 22, 2015 at 6:26

Add a comment |

1 Answer 1