/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 vote301 views1 answer
Angular input change event datatype typescript
TypeScript
-1 vote390 views1 answer
Enter into postgresql database AS
TypeScript
3 votes327 views1 answer
Adonis validator optional
TypeScript
0 vote307 views2 answers
Angular start date end date validation
TypeScript
0 vote313 views2 answers
Typeorm field relation not showing
TypeScript
0 vote334 views2 answers
How to find the total of the products added to the shopping cart in java program
TypeScript
-1 vote354 views2 answers
Module '"@angular/fire/firestore"' has no exported member 'AngularFirestore'
TypeScript
2 votes341 views1 answer
Ts change date format
TypeScript
1 vote323 views2 answers
Woocommerce bulk product delete
TypeScript
0 vote344 views1 answer
My bootstrap alerts code is not closing
TypeScript

Share