/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

22 votes183 views2 answers
React native typescript children prop
TypeScript
5 votes185 views2 answers
Javascript float element right
TypeScript
2 votes186 views1 answer
Ts-node call function from command line
TypeScript
0 vote184 views1 answer
Sort even dont exists meta wordpress
TypeScript
0 vote183 views2 answers
Array objects to array of one property
TypeScript
6 votes198 views4 answers
Data
TypeScript
0 vote187 views1 answer
@babel/preset-typescript
TypeScript
0 vote202 views1 answer
How to use array pop in typescript
TypeScript
10 votes218 views3 answers
Typescript array of object with types
TypeScript
87 votes279 views6 answers
Typescript random number
TypeScript

Share