/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

0 vote185 views3 answers
Saving leaderstats script roblox
TypeScript
1 vote185 views1 answer
Serenity.-is add column picker button
TypeScript
19 votes177 views4 answers
Sort array of objects by string property value
TypeScript
0 vote186 views1 answer
Dwayne johnson maui
TypeScript
0 vote194 views1 answer
How to write elements of a list as a string with a comma between elements in python
TypeScript
0 vote185 views2 answers
Angular 9 : Error NG2003: No suitable injection token for parameter 'url' of class 'DataService'. Found string
TypeScript
0 vote171 views1 answer
Pass data through router angular
TypeScript
0 vote158 views1 answer
React.ComponentProps<T>
TypeScript
0 vote204 views2 answers
Eslint absolute imports error
TypeScript
0 vote180 views1 answer
Behaviour
TypeScript

Share