/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

4 votes263 views3 answers
Typescript get current timestamp
TypeScript
-1 vote159 views2 answers
How to pass props in typescript
TypeScript
-1 vote199 views2 answers
Hhow to remove elements from java
TypeScript
0 vote205 views1 answer
Piechart am4charts legend with actual values
TypeScript
19 votes207 views3 answers
Set default route angular
TypeScript
0 vote180 views1 answer
Property control in spotfire doest not exist on abstractcontrol
TypeScript
10 votes209 views3 answers
Typescript foreach
TypeScript
0 vote180 views1 answer
How are uv rays produced
TypeScript
4 votes206 views3 answers
Cors npm typescript
TypeScript
5 votes178 views2 answers
How many states of matter are there
TypeScript

Share