/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

2 votes317 views2 answers
Valid jwt
TypeScript
1 vote355 views1 answer
++i vs i++
TypeScript
0 vote330 views1 answer
Lite-server cannot be loaded because running scripts is disabled on this system
TypeScript
3 votes331 views3 answers
Typescript for loop key value pai
TypeScript
6 votes331 views2 answers
Refused to apply style from 'http://localhost:9000/public/css/style.css' because its MIME type ('text/html') is not a supported stylesheet MIME type, and strict MIME checking is enabled.
TypeScript
0 vote337 views1 answer
How to loop the jquery formData key object in jqueyr
TypeScript
0 vote326 views1 answer
Behaviour
TypeScript
1 vote356 views1 answer
Typescript json.parse
TypeScript
1 vote332 views1 answer
Global d ts
TypeScript
0 vote319 views1 answer
Check if username exists in database django
TypeScript

Share