How to do Pattern Matching in SQL using Wild Card Characters | Like Operator in SQL

[@SACHINKUMAR-px8kq]

Hara Phool Neela phool , Sir ki SQL classes Beautiful😀

[@ankitbansal6]

Haha

[@SHIVAMSHARMA-pb2lt]

Hi Ankit. To begin with, a very Big thanks to you for presenting SQL in such a comprehensive manner. The understanding behind your explanation is a clear mandate of the hardwork you have put in over the years. It would be of great use and privilege if you can make a dedicated series on SQL starting from the basics to advanced level. Indeed we get what you explain but for beginners it is tough to implement that on their end . In the meantime, if possible Please give a roadmap of how you learnt SQL and what are the resources you have used to start from basics to advanced. Thank you

[@ankitbansal6]

Thank you. Sure will do that 🙂

[@analyticalguy]

Hi Shivam, you can watch this SQL series for FREE practical guide to SQL. kzbin.info/www/bejne/n6O7lWSPm5V8rbM

[@rohitagrawal769]

Thanks buddy!! God bless you and your family!!

[@ankitbansal6]

🙏🙏

[@Manjunath_pai]

Very clear and crisp explanation

[@ankitbansal6]

Thank you 😊

[@florincopaci6821]

Thank you for all the videos!

[@ankitbansal6]

Glad you like them!

[@shashankemani1609]

Pretty useful. Thank you so much!

[@ankitbansal6]

Glad it was helpful!

[@amazingriknow5986]

Awesome Ankit

[@ankitbansal6]

Thank you !!

[@jojven7514]

Awesome 😎😎👏👍

[@ankitbansal6]

Thank you! Cheers!

[@kundankumar5520]

Hi Sir, thanks again for this amazing content

[@tharanga835]

Hi Sir, your videos are very useful and I got confident in sql please do more videos on 'Python data analysis Panda' series

[@ankitbansal6]

Sure I will

[@subalakshmijayakumar4336]

Hello Sir, Thanks for sharing the wild card concept. Can you please do a Conceptual video on Reg expression with real tume example. Hope will be helpful for many.

[@ankitbansal6]

Great suggestion! Will do that.

[@revathigangisetty5734]

Superrrr.

[@harishbadiger4800]

Hi Ankit, For example in the Name "Spandana" or for that matter any name you can take. Get me the second occurrence of character 'a' from the name. or what function should we use? Please make video in type conversion / type casting of column data types using minus operator by taking some example

[@alitalhavlogs]

Thank you very well explained.

[@ankitbansal6]

Glad you liked it

[@ashish31416]

Thank you so much

[@minuhukare]

very nice explaination sir

[@ankitbansal6]

Keep watching

[@rajeevranjan7972]

can you pls produce output col from rest three columns as shown below: ID file Com output 1 04-11-2022 Amazon 1 1 05-11-2022 Amazon 1 1 06-11-2022 Amazon 1 1 07-11-2022 Apple 1 1 08-11-2022 Apple 1 1 09-11-2022 Apple 1 1 10-11-2022 Amazon 2 1 11-11-2022 Amazon 2 1 12-11-2022 Apple 2 1 13-11-2022 Apple 2 1 14-11-2022 Apple 2 1 15-11-2022 beer 1 1 16-11-2022 beer 1 1 17-11-2022 beer 1 1 18-11-2022 beer 1 1 19-11-2022 beer 1 1 20-11-2022 Amazon 3 1 21-11-2022 Amazon 3 1 22-11-2022 Amazon 3 1 23-11-2022 mango 1 1 24-11-2022 mango 1 Got this in an interview and I was not able to solve in 10 min. Pls help

[@alfinashaik3946]

@Ankit can you please help solving this?

[@monasanthosh9208]

Select ID,File,Company,RN1 from (Select *,dense_rank() over (Partition by Company Order by RN) as RN1 from (Select *,subdate(File,interval dense_Rank() over (Partition by Company Order by File) day) as RN from Product)N)N1 order by File; Thank you for Sharing this Question

[@nikhilkumarsampath7938]

Can I get the link for downloading the dataset, sir? @ankitbansal