/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

0 vote320 views1 answer
Wordpress number of posts by user
TypeScript
0 vote328 views1 answer
Node fetch image to base64
TypeScript
0 vote290 views1 answer
HIGHER-ORDER FUNCTIONS with two parameters
TypeScript
0 vote299 views1 answer
Fechas - Solución resta un día en dato
TypeScript
0 vote294 views1 answer
Convert c# class to typescript
TypeScript
9 votes310 views4 answers
Angular scroll to top
TypeScript
0 vote279 views1 answer
Display only user contributor comments wordpress
TypeScript
0 vote320 views1 answer
Typescript dynamic type
TypeScript
0 vote287 views1 answer
Online doctor appointments in pakistan
TypeScript
0 vote307 views1 answer
Difference in minutes between 2 time inputs laravel
TypeScript

Share