SQL Interview Questions | How to find number of emails from the same domain | CharIndex

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

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

50% 1

In this video, we write a SQL Query to count the emails from the same domain
How to install SQL Server?
• How to install SQL Ser...
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.com/company/know...
Email - learn@knowstar.org

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

1 сен 2021

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

Thanks for this video... I have learned new way to findout domain names_ easiest way! If possible do cover by using substring also

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

Very useful...thank you

@enriquewilliams44 Год назад

Awesome video! Thanks for explaining this so well.

@LearnatKnowstar Год назад

Thank you

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

Thank You .

@BalajiVenkatraman21 2 месяца назад

I've watched your most of the videos, I've noticed you haven't shared the data set used in the SQL query. Could you provide a dataset that would be helpful for us to practice with?

@kshirod_behera 7 месяцев назад

Thank you. Very good explanation. I was faced with this type of question in my recent interviews.

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

Glad it was helpful!

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

Hi Maam, my self zuheb...I have 10 year of experience into reporting....now I learning the SQl....Request you to prepare some videos on Stored procedure in mssql with complex join as....Interviewer are asking...it will be great help and flow along with you.. Thanks in advance

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

Sure, will plan the videos soon. Thank you and keep checking our latest videos !

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

Good 👍

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

Thank you

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

Very useful. Thank you. I asked one question but still I didn't get the solution of that query..

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

Thanks. Could you please post your query again. Will surely try to answer.

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

@@LearnatKnowstar Hello Madam, I am one of your subscriber and I really appreciate your work and way of teaching.I have one query related to SQL. Can you please provide solution of this query. Input Id Value 1 1 2 a 3 2 4 b 5 c Output Id Number_value Character_value 1 1 a 2 2 b 3 c Write SQL query to get the desired Output.Thank you in advance

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

How to write the above query using substring function as you have mentioned in the video in between.

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

select count(substr(mail_id,(instr(mail_id,'@',1,1))+1)), substr(mail_id,(instr(mail_id,'@',1,1))+1) from mail_id group by substr(mail_id,(instr(mail_id,'@',1,1))+1);

@KiranHarijan-ih7pg Год назад

Eg name 'SARA' I want to know the last 'A' position so how to write using CharIndex?

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

do yourself a regex CLR, and don't bother with poor native SQL string functions. one thing SQL sucks at - is parsing strings... ones that exist are fast but they are far away from being modern and sufficient to do a job