In this tutorial, we learn how to extract the last occurrence of a substring.
The SQL function used is REVERSE.

We work on two solutions –
1) How to extract file extension from filename?
2) How to extract filename from Physical path

The practice dataset and SQL statements are available here-
https://know-star.blogspot.com/2022/11/sql-how-to-find-last-occurrence-of.html

How to install SQL Server for practice?
https://www.youtube.com/watch?v=ncj0EDzy_rw&t=298s

Check out the complete list of SQL Query Interview Questions –
https://www.youtube.com/watch?v=AhapksIsHxg&list=PL2-GO-f-XvjBl5fpzdfYaPW28PwsLzLc4

Best Data Science / Analytics / SQL courses
Learn SQL Basics for Data Science Specialization
https://imp.i384100.net/qnXYk5

Beginners to Python Programming
https://skillshare.eqcm.net/GjMakm

Data Science and Business Analytics with Python
https://skillshare.eqcm.net/JrM1Aq

Get 40% OFF of Skillshare with code FLASH40 – October 2022
https://skillshare.eqcm.net/c/3299742/1477682/4650

Data Science Fundamentals with Python and SQL Specialization
https://imp.i384100.net/mgVYre

Python for Everybody Specialization
https://imp.i384100.net/DVz7Aj

Google Data Analytics Professional Certificate
https://imp.i384100.net/OR37oQ

Coursera Plus – Data Science Career Skills
https://imp.i384100.net/c/3299742/1320998/14726

Please do not forget to like, subscribe and share.

Need a break from all the SQL talk?
Why dont’ you follow us on our new travel photography instagram account here –
https://www.instagram.com/travelz.a2z/

For enrolling and enquiries, please contact us at
Website – http://knowstar.org/
Facebook – https://www.facebook.com/knowstartrainings/
Linkedin – https://www.linkedin.com/company/knowstar-e-learning-solutions/?viewAsMember=true
Email – [email protected]