/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 vote235 views1 answer
Shortcuts for ajax in vscode
TypeScript
0 vote266 views1 answer
Casting objects in flutter or dart
TypeScript
0 vote240 views2 answers
Get string in brackets python
TypeScript
0 vote230 views1 answer
E typescript
TypeScript
30 votes249 views10 answers
Google Translate
TypeScript
1 vote236 views1 answer
Check if a date is before another date in typescript
TypeScript
91 votes393 views5 answers
How to get last element of array in typescript
TypeScript
1 vote236 views1 answer
Json to object typescript
TypeScript
0 vote240 views1 answer
Typescript filter list of objects based on latest date
TypeScript
1 vote256 views1 answer
Andonis many to many detach
TypeScript

Share