SQL Challenge - Problem and Solution | Using Wildcards
This is a SQL Solution video for two problems which can be asked in any SQL interviews.
____________________________________
Problem Statements -
⭕1. Query the list of CITY names from Sales table that start with vowels and end with vowels. Your result cannot contain duplicates.
____________________________________
⭕2. Query the list of CITY names from Sales table that do not start with vowels and do not end with vowels. Your result cannot contain duplicates.
____________________________________
⭕We will use Wildcards to filter out the results. Watch the whole video carefully to find out the solution.
For more videos and challenges on SQL... Please Subscribe to my channel "Let's Learn".
____________________________________
⭕ YouTube Channel - / letslearn-in
____________________________________
⭕ Check out our SQL Playlist -
• Learn SQL!
⭕ To understand the Wildcards concept in SQL -
• Wildcards in SQL
⭕ Channel Link -
/ @letslearn-in
⭕ Press the 🔔 icon and never miss an update.
⭕ You can also follow us on Instagram, Facebook and Twitter : @letuslearnindia
__
Let's Learn
➖➖➖➖➖➖➖➖➖➖➖
#SQL #DBA #SQLServer
#Database #SQLforbeginners
#coding #codinglife
#dbadmin #Wildcards