/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 vote261 views1 answer
Haskell get specific elements of a String
TypeScript
0 vote204 views1 answer
Typescript trim spaces in string array
TypeScript
1 vote218 views1 answer
Rscript arguments input
TypeScript
0 vote215 views1 answer
Difference between statistical learning and machine learning
TypeScript
0 vote198 views1 answer
Ts console.log
TypeScript
2 votes228 views2 answers
Close mat dialog from component
TypeScript
1 vote205 views1 answer
Circle dot in latex
TypeScript
0 vote196 views1 answer
Sts is not opening in mac
TypeScript
0 vote235 views1 answer
Can't bind to 'ngbCollapse' since it isn't a known property of 'div'
TypeScript
0 vote231 views1 answer
Class-transformer default value
TypeScript

Share