SQL Server Trainers

SQL LIKE Operator

The LIKE operator is used to list all rows in a table whose column values match a specified pattern. It is useful when you want to search rows to match a specific pattern, or when you do not know the entire value. For this purpose we use a wildcard character ‘%’.

For example: To select all the students whose name begins with ‘S’

SELECT first_name, last_name
FROM student_details
WHERE first_name LIKE ‘S%’;

The output would be similar to:

first_name          last_name
————-          ————-
Stephen                 Fleming
Shekar                   Gowda

The above select statement searches for all the rows where the first letter of the column first_name is ‘S’ and rest of the letters in the name can be any character.

SQL School Training Courses & Jobs

SQL School Training Courses & Jobs

 

SQL School provides real-time trainings, projects and Jobs on various technologies including SQL Server, SQL DBA, MSBI, Power BI, Microsoft Azure, PL SQL, Oracle DBA, RAC DBA, Oracle Golden Gate and DataScience. We have experienced and certified trainers on these technologies.  

 

SQL School (www.sqlschool.com) have been providing trainings, placements and projects for more than TEN years and working with many MNCs for their direct training requirements including ADP, MindTree, Sonata, L& T, and many more. Few of the recent invoices can be found at www.sqlschool.com/clients 

 

Call us today for free demo.  

Toll Free: +91 90 1434 1434 

 

For Microsoft Technologies:  http://www.sqlschool.com 

 

For Oracle Technologies:  http://www.sqlschool.com/oracle 

 

For DataScience Technologies:  http://www.sqlschool.com/DataScience 

 

SQL School Training Courses & Jobs

#SQLSchool #Trainings #Projects #Jobs #SQLServer #T-SQL #SQLDBA #MSBI #PowerBI #Azure #PLSQL #OracleDBA #RACDBA #DataScience #Trainers 

SQL School Training Courses on Microsoft, Oracle and Data Science

SQL School Training Courses & Jobs