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%' ;
Important Interview Question