SQL Server Course for Beginners with 100+ examples - MAX() Function

The video tutorial explains the use of the LIKE and NOT LIKE operators in SQL for pattern matching within database columns. It covers basic and advanced examples, demonstrating how to filter records based on specific patterns using wildcards like '%' and '_'. The tutorial also shows how to apply these operators to employee names and city records, providing practical SQL query examples.

What is the purpose of the LIKE operator in SQL?

• To join two tables

• To sort data in ascending order

• To match patterns in text

• To perform arithmetic operations

Which symbol is used with the LIKE operator to match zero or more characters?

• Hash (#)

• Underscore (_)

• Percentage (%)

• Asterisk (*)

How would you select employee names starting with 'T' using the LIKE operator?

• SELECT * FROM employee WHERE name LIKE 'T_'

• SELECT * FROM employee WHERE name LIKE '_T'

• SELECT * FROM employee WHERE name LIKE '%T'

• SELECT * FROM employee WHERE name LIKE 'T%'

What would be the result of using the query: SELECT * FROM employee WHERE city LIKE 'A%'?

• Cities ending with 'A'

• Cities containing 'A'

• Cities starting with 'A'

• Cities with 'A' in the second position

Which employee names will be selected with the query: SELECT * FROM employee WHERE name LIKE '%I'?

• Names starting with 'I'

• Names ending with 'I'

• Names with 'I' in the second position

• Names containing 'I'

How can you select employee names with 'E' as the second character?

• SELECT * FROM employee WHERE name LIKE 'E%'

• SELECT * FROM employee WHERE name LIKE '_E%'

• SELECT * FROM employee WHERE name LIKE '%E_'

• SELECT * FROM employee WHERE name LIKE 'E_'

What does the NOT LIKE operator do in SQL?

• Sorts records in descending order

• Excludes records matching a pattern

• Includes records matching a pattern

• Joins records from two tables