/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 vote254 views1 answer
On input inset - afetr 5 digits jquery
TypeScript
2 votes254 views1 answer
Covid south africa update
TypeScript
38 votes317 views3 answers
Cannot be loaded because running scripts is disabled on this system. For more information, see about_Execution_Policies at https:/go.microsoft.com/fwlink/?LinkID=135170.
TypeScript
0 vote295 views2 answers
Eslint absolute imports error
TypeScript
1 vote245 views1 answer
How to print the results of a command in a fil in linux
TypeScript
0 vote239 views1 answer
Can we do system testing at any stage
TypeScript
0 vote255 views1 answer
Check runnong ports ubuntu
TypeScript
2 votes262 views2 answers
Cannot use JSX unless the '--jsx' flag is provided.ts(17004)
TypeScript
0 vote252 views1 answer
Get type of element of array typescript
TypeScript
2 votes257 views10 answers
Robux
TypeScript

Share