/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

3 votes201 views1 answer
Intersection between two sets python
TypeScript
9 votes256 views3 answers
Create next app typescript
TypeScript
2 votes195 views1 answer
Iterate dictionary ts
TypeScript
1 vote188 views1 answer
Python check if attribute exists in class
TypeScript
0 vote198 views1 answer
Servlets meaning
TypeScript
1 vote225 views1 answer
@angular/fire/angularfire2.d.ts:37:49 - error TS2344: Type 'T[K]' does not satisfy the constraint '(...args: any) => any
TypeScript
0 vote194 views1 answer
Check if package exists inside the device adb
TypeScript
0 vote223 views1 answer
Mat stepper dont clickable
TypeScript
0 vote202 views1 answer
Powershell see ports in use
TypeScript
0 vote215 views2 answers
"Type error: ReflectionFunction::__construct() expects parameter 1 to be string, array given"
TypeScript

Share