/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 vote276 views1 answer
Typescript export interface array
TypeScript
0 vote278 views1 answer
Shortcut to remove unused imports in vscode
TypeScript
3 votes196 views1 answer
How to remove an entry from a dictionary python
TypeScript
0 vote277 views1 answer
Print query from get_posts wordpress
TypeScript
0 vote252 views2 answers
Accept the SDK license agreements and install the missing components using the Android Studio SDK Manager
TypeScript
15 votes260 views2 answers
Typescript string to enum
TypeScript
22 votes258 views3 answers
String to int typescript
TypeScript
1 vote292 views1 answer
Serenity.-is add column picker button
TypeScript
1 vote261 views1 answer
Typescript json.parse
TypeScript
0 vote270 views1 answer
List of american tanks
TypeScript

Share