/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 vote260 views1 answer
Check if all elements in array can be divided by python
TypeScript
0 vote276 views2 answers
Npm clean
TypeScript
-1 vote288 views1 answer
Components of api request
TypeScript
0 vote265 views1 answer
Tell me about your Automation strategy of manual test cases
TypeScript
10 votes270 views3 answers
Typescript foreach
TypeScript
0 vote266 views1 answer
R merge lists with common elements
TypeScript
65 votes448 views5 answers
\ng.ps1 cannot be loaded because running scripts is disabled on this system.
TypeScript
0 vote262 views6 answers
Python double check if wants to execute funtion
TypeScript
19 votes253 views4 answers
Material ui icon npm
TypeScript
5 votes264 views3 answers
Typescript with nodemon
TypeScript

Share