SQL Interview Query | How to find the closest matching string | best match | 2 methods

Check out the complete list of SQL Query Interview Questions -

Please do not forget to like, subscribe and share.

For enrolling and enquiries, please contact us at

[whitecrowuk]

Soundex is a phonetic algorithm so two words that sound the same but spelled different will have the same code representation. So you can’t use it really to compare strings as smith and smyth will be the same even though are different

[awakenedcodex]

Some really interesting, less common approaches on this channel, or at least not too common around where I'm from, never seen any of that specifically or with that much detail throughout the years of spending time with sql stuff, nice channel in general, a well deserved sub :)

[tamoorkhan]

Thank you so much, God bless you more....my big problem is resolved by your video... Thanks again

[JasonDimmick]

Ummm, the Difference function automatically does the soundex function on the two parameters.

[achyugonu]

nice video. new subscriber. if we alias the difference column then we can use the aliased name instead of the whole difference formula in the order by.

[ismsult]

Thanks
how can do that on hundreds numbers one time ?

[kalimishra]

Can you please suggest we can use parameters in both query.

[ArabianHorse]

Very nice and wonderful . Greeting from Misr (Misr is the arabic name of Egypt)

[anhhaopham]

Thank you very much sir. How can i download example data in video sir ?

[prakashs]

Nice video, Please do all kinds of logical operators in one sample query, with multiple tables.

[educationcounselor]

Select rivername, len(rivername) from table
Where rivername like '%nile%'
Order by len(rivername) asc;
Will this work??

[MiningForPies]

Soundex is a very simplistic check. Beware when using it on things like names as it takes no account of localised accents or pronunciation.

[saurabhyadav-numj]

Hello ma'am, this was a wonderful video, can you also please create a video on fuzzy matching in SQL

[kingstonxavier]

Learnt something new, Thanks a lot :)

[ganeshtekkali]

how to find yellow form c1 and c2 and c3 columns without using the max query?

[muralikrishnachowdarypolin]

Hi How to create sql id with date and number date is changed numver start with 1

[ABCXYZ-kgik]

how to identify if the sentence contain Chinese string? And how to extract Chinese characters from the sentence?

[adityaraopandrapagada]

Hi Mam, Outputs doesn't match... Can you clarify

[andy]

Why you are not using CHARINDEX function?

[namratawedding]

Why not just order by length of river name...That would yield the same result.