/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 vote301 views1 answer
Size of list applescript
TypeScript
7 votes286 views3 answers
If temp table exists drop
TypeScript
22 votes303 views4 answers
Generate random numbers in python within a range
TypeScript
-1 vote290 views1 answer
Typescript dictionary contains key
TypeScript
0 vote321 views1 answer
Ts new example
TypeScript
-1 vote361 views1 answer
Top data scientists in the world
TypeScript
6 votes329 views1 answer
Check if key is in the js object
TypeScript
8 votes307 views3 answers
L'exécution de scripts est désactivée sur ce système.
TypeScript
0 vote320 views1 answer
Python shuffle two lists together
TypeScript
3 votes296 views1 answer
Intersect sets python
TypeScript

Share