/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

2 votes313 views2 answers
Remove all the elements from a numpy array python
TypeScript
0 vote317 views1 answer
Import xml elements in kotlin
TypeScript
5 votes331 views4 answers
Wget
TypeScript
0 vote337 views1 answer
Reverse a string if its value its greater than 3
TypeScript
10 votes324 views2 answers
How to use variable as object key in typescript
TypeScript
0 vote297 views1 answer
Get database num hits django
TypeScript
0 vote317 views1 answer
Who indirectly elects the president
TypeScript
1 vote336 views1 answer
What are data points
TypeScript
0 vote300 views5 answers
Rosa
TypeScript
0 vote295 views1 answer
Object is possibly
TypeScript

Share