/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 vote197 views1 answer
IM DEAD
TypeScript
0 vote244 views1 answer
React dynamic inputs with id
TypeScript
3 votes170 views3 answers
Remove duplicate objects based on id from array angular 8
TypeScript
0 vote193 views1 answer
Create react app with typescript declare types for libraries in npm
TypeScript
1 vote175 views2 answers
Typescript get the promise return type
TypeScript
2 votes186 views2 answers
How to find a combination of all elements in a python list
TypeScript
0 vote195 views1 answer
Could not read Username for 'https://github.com': terminal prompts disabled
TypeScript
2 votes191 views1 answer
Typescriprt specify type of key
TypeScript
0 vote193 views1 answer
Highcharts print
TypeScript
1 vote187 views1 answer
Requests use many proxy python
TypeScript

Share