/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 vote168 views1 answer
Can't bind to 'mat-dialog-close' since it isn't a known property of 'button'
TypeScript
1 vote168 views1 answer
Display digital clock in angular
TypeScript
0 vote159 views2 answers
Accept the SDK license agreements and install the missing components using the Android Studio SDK Manager
TypeScript
0 vote178 views3 answers
Get local storage data in angular
TypeScript
-1 vote163 views2 answers
Function that redirects to another page react
TypeScript
1 vote175 views1 answer
How to Pass Arguments to a Bash Script
TypeScript
0 vote168 views1 answer
How to get value from observable
TypeScript
0 vote205 views1 answer
No database host was found that meets the requirements for this server.
TypeScript
0 vote209 views1 answer
Tar contents of current folder
TypeScript
0 vote162 views1 answer
Window global typescript
TypeScript

Share