/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

1 vote275 views1 answer
Whats my country
TypeScript
1 vote289 views1 answer
Js split string with emoji
TypeScript
0 vote315 views1 answer
1.Load the data set cats from the library MASS
TypeScript
0 vote295 views1 answer
Check in Recat if an url is of image or video
TypeScript
0 vote316 views1 answer
The derived ungapped alignments are calleed
TypeScript
3 votes309 views2 answers
Foreach on dictionary in typescript
TypeScript
4 votes233 views1 answer
Typescript update
TypeScript
6 votes308 views2 answers
Typescript how to create an array instance
TypeScript
2 votes298 views1 answer
Types date typescript
TypeScript
0 vote302 views2 answers
Typeorm select join column querybuilder
TypeScript

Share