No video :(

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

Learn at Knowstar

Подписаться 44 тыс.

Просмотров 24 тыс.

50% 1

Видео Поделиться Скачать Добавить в

Check out the complete list of SQL Query Interview Questions -
• SQL Query Interview Qu...
Please do not forget to like, subscribe and share.
For enrolling and enquiries, please contact us at
Website - knowstar.org/
Facebook - / knowstartrainings
Linkedin - www.linkedin.c...
Email - learn@knowstar.org

Опубликовано:

21 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 44

@whitecrowuk575 Год назад

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

@awakenedcodex3766 2 года назад

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 :)

@LearnatKnowstar 2 года назад

Thank you for your support!

@tamoorkhan3799 10 месяцев назад

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

@LearnatKnowstar 10 месяцев назад

Glad it was helpful.

@shreyaroraa2234 2 года назад

Learnt something new. Wonderful

@LearnatKnowstar 2 года назад

Thank you

@dimpyrathore818 2 года назад

Amazing content as always

@LearnatKnowstar 2 года назад

Thank you

@ArabianHorse 2 года назад

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

@LearnatKnowstar 2 года назад

Thank you

@kingstonxavier 2 года назад

Learnt something new, Thanks a lot :)

@LearnatKnowstar 2 года назад

Thank you

@achyugonu 2 года назад

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.

@LearnatKnowstar 2 года назад

Thank you

@prakashs8009 2 года назад

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

@LearnatKnowstar 2 года назад

Thank you

@MiningForPies 2 года назад

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

@jiarong6586 Год назад

Very useful！ Thank you！😊

@LearnatKnowstar Год назад

Glad it was helpful!

@ganapathivavilapalli3176 2 года назад

Wonderful explanation

@LearnatKnowstar 2 года назад

Thank you

@saurabhyadav-nu3mj 2 года назад

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

@LearnatKnowstar 2 года назад

Thank you. Sure, we have planned some videos which will be posted soon.

@jagadesh4220 2 года назад

Super....hands off

@LearnatKnowstar 2 года назад

Thank you

@educationcounselor7946 2 года назад

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

@JasonDimmick Год назад

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

@anhhaopham7919 2 года назад

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

@ravihirani4182 2 года назад

Thanks for sharing 👍

@LearnatKnowstar 2 года назад

Thank you

@kalimishra818 2 года назад

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

@user-ox1pg5xn1d 2 месяца назад

Thanks how can do that on hundreds numbers one time ?

@ganeshtekkali5094 2 года назад

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

@ABCXYZ-kg7ik 2 года назад

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

@namratawedding1401 2 года назад

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

@muralikrishnachowdarypolin5601 2 года назад

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

@adityaraopandrapagada1894 2 года назад

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

@muralikrishnachowdarypolin5601 2 года назад

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

@andy239 2 года назад

Why you are not using CHARINDEX function?

@Kreadus005 Год назад

Jarowinkler?

@LearnatKnowstar Год назад

In python

@Kreadus005 Год назад

Or a .NET CLR procedure

@syedzaid4346 8 месяцев назад

what if there is a wrong spelling

Далее

SQL Amazing Trick | Dynamically Pass Values to IN clause | Parametrize Values | String_Split

9:34

SQL Amazing Trick | Dynamically Pass Values to IN clause | Parametrize Values | String_Split

Просмотров 38 тыс.

SQL Interview | Employee with closest salary to average salary in a department | nearest values

12:33

SQL Interview | Employee with closest salary to average salary in a department | nearest values

Просмотров 9 тыс.

Доказали ли японцы, что человек на 78% состоит из воды? Алексей Водовозов.

00:52

Доказали ли японцы, что человек на 78% состоит из воды? Алексей Водовозов.

Просмотров 66 тыс.

Putin Bakıya gecəylə niyə və necə gəldi? Ərdoğan Əliyevə niyə zəng etdi?

34:31

Putin Bakıya gecəylə niyə və necə gəldi? Ərdoğan Əliyevə niyə zəng etdi?

Просмотров 263 тыс.

КИТАЙСКИЙ ЭПОС ➤ Black Myth: Wukong ◉ Прохождение 1

3:51:06

КИТАЙСКИЙ ЭПОС ➤ Black Myth: Wukong ◉ Прохождение 1

Просмотров 175 тыс.

2к ММР игроки в РЕЖИМЕ ТУРБО против КОМАНДЫ ТИТАНОВ в ALL PICK 😱

40:59

2к ММР игроки в РЕЖИМЕ ТУРБО против КОМАНДЫ ТИТАНОВ в ALL PICK 😱

Просмотров 495 тыс.

Fuzzy string matching using Python

7:46

Fuzzy string matching using Python

Просмотров 67 тыс.

SQL Interview Question | What is the difference between Translate and Replace

9:11

SQL Interview Question | What is the difference between Translate and Replace

Просмотров 9 тыс.

Forward Fill Null Values - 2 WAYS TO SOLVE | Tricky SQL Questions

11:23

Forward Fill Null Values - 2 WAYS TO SOLVE | Tricky SQL Questions

Просмотров 456

How To Load One BILLION Rows into an SQL Database

12:17

How To Load One BILLION Rows into an SQL Database

Просмотров 33 тыс.

SQL Query | How to extract numbers from String | Split word into characters | Two methods

17:18

SQL Query | How to extract numbers from String | Split word into characters | Two methods

Просмотров 18 тыс.

SQL JOINS Interview Question | What does different SQL Joins return?

25:17

SQL JOINS Interview Question | What does different SQL Joins return?

Просмотров 425 тыс.

Fuzzy String Matching (Query Tuning)

8:24

Fuzzy String Matching (Query Tuning)

Просмотров 850

SQL Basics for people with no prior knowledge 🤷‍♀️🤷‍♂️

9:45

SQL Basics for people with no prior knowledge 🤷‍♀️🤷‍♂️

Просмотров 178 тыс.

Top 5 Advanced SQL Interview Questions and Answers | Frequently Asked SQL interview questions

36:59

Top 5 Advanced SQL Interview Questions and Answers | Frequently Asked SQL interview questions

Просмотров 47 тыс.

SQL Interview Question | How to find departments having only male / female employees?

11:54

SQL Interview Question | How to find departments having only male / female employees?

Просмотров 24 тыс.

Доказали ли японцы, что человек на 78% состоит из воды? Алексей Водовозов.

00:52

Доказали ли японцы, что человек на 78% состоит из воды? Алексей Водовозов.

Просмотров 66 тыс.