/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

7 votes303 views2 answers
Check if column exists in dataframe python
TypeScript
2 votes285 views1 answer
Typescript initialize map inline
TypeScript
1 vote268 views1 answer
Window typescript
TypeScript
0 vote347 views1 answer
Whats the difference between let and const lol
TypeScript
-1 vote264 views1 answer
10 elements of gothic literature
TypeScript
22 votes289 views3 answers
Typescript remove an item from array
TypeScript
0 vote250 views1 answer
Change div with css
TypeScript
15 votes281 views3 answers
How to check if a variable exists in python
TypeScript
0 vote272 views1 answer
Does not use passive listeners to improve scrolling performance
TypeScript
15 votes298 views2 answers
Python get file contents as string
TypeScript

Share