/TypeScript/Write an SQL query to fetch details of employees whose name starts with an alphabet 'A' and contains 10 alphabets.

Write an SQL query to fetch details of employees whose name starts with an alphabet 'A' and contains 10 alphabets.

Sql print all names that start with a given letter

select employee_name 
from employees
where employee_name LIKE 'A%' OR employee_name LIKE 'B%'
order by employee_name

3

Source: stackoverflow.com

Write an SQL query to fetch details of employees whose name starts with an alphabet 'A' and contains 10 alphabets.

select employee_name 
from employees
where employee_name LIKE 'A%' OR employee_name LIKE 'B%' AND length(employee_name) >11
order by employee_name

0

Similar codes

7 votes146 views4 answers
Typescript array
TypeScript
0 vote155 views1 answer
What is the reason we are using properties file
TypeScript
1 vote147 views1 answer
Sequelize is not null
TypeScript
1 vote157 views1 answer
Vetur change tsconfig location
TypeScript
0 vote155 views1 answer
Total infosys employees
TypeScript
37 votes195 views3 answers
Angular date pipe 24 hour format
TypeScript
5 votes144 views1 answer
Req.user typescript
TypeScript
0 vote149 views1 answer
Print contents of cpp file
TypeScript
7 votes150 views2 answers
Loop an object properties in ts
TypeScript
0 vote154 views1 answer
Cannot find module 'ng2-pdf-viewer' or its corresponding type declarations
TypeScript

Share