/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 votes231 views2 answers
Angular jasmine mock http request
TypeScript
1 vote267 views1 answer
Nextjs global prisma
TypeScript
0 vote213 views1 answer
How to store image in realtime firebase using angularfire2 and angular 8
TypeScript
0 vote235 views1 answer
Are remote objects and distributed objects the same
TypeScript
0 vote217 views1 answer
Usage: testing_caption_generator.py [-h] -i IMAGE testing_caption_generator.py: error: the following arguments are required: -i/--image An exception has occurred, use %tb to see the full traceback.
TypeScript
0 vote221 views1 answer
Idle angular 15 menute
TypeScript
0 vote250 views1 answer
Typescript clearinterval not working
TypeScript
1 vote239 views1 answer
How to reset stats in diablo 2
TypeScript
2 votes224 views1 answer
Check subnets docker
TypeScript
0 vote233 views1 answer
Typescript get object value
TypeScript

Share