Write an SQL query to find names of employee start with 'A'?

86 Views

Write an SQL query to find names of employee start with 'A'?

SQL | LIKE operator

The LIKE operator of SQL is used for such kind of operations. It is used to fetch filtered data by searching for a particular pattern in where clause.

 

The Syntax for using LIKE is,

SELECT column1, column2, ...
FROM table_name
WHERE columnN LIKE pattern;

The required query is:

 SELECT * FROM employees WHERE empName like 'A%' ;

 

Tags:-
SQL
MySQL

Today spacial posts