/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 vote163 views2 answers
Typeorm field relation not showing
TypeScript
0 vote156 views1 answer
Highcharts turbothreshold not working
TypeScript
1 vote172 views1 answer
How to init tscondif
TypeScript
0 vote284 views1 answer
Loadsh partial match filter
TypeScript
7 votes165 views1 answer
Mongodb exists and not null
TypeScript
1 vote173 views2 answers
Subplots matplotlib
TypeScript
1 vote153 views1 answer
Prevent row click event when button is clicked angular html
TypeScript
53 votes487 views4 answers
Digits of pi
TypeScript
1 vote167 views1 answer
React functional components setstate callback
TypeScript
2 votes175 views1 answer
Merge properties of object typescript
TypeScript

Share