/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

-1 vote227 views2 answers
React-helmet typescript
TypeScript
0 vote228 views1 answer
Cypress not defined
TypeScript
1 vote213 views1 answer
Is id in array typescript
TypeScript
1 vote210 views1 answer
How to send data between components in react with redirect
TypeScript
1 vote194 views1 answer
Edit card-deck breakingpoints bootstrap
TypeScript
1 vote251 views1 answer
Import js file in typescript
TypeScript
5 votes193 views2 answers
Lofi hip hop beats to study to
TypeScript
0 vote228 views1 answer
Beautifulsoup search for elements with attributes
TypeScript
65 votes522 views5 answers
\ng.ps1 cannot be loaded because running scripts is disabled on this system.
TypeScript
0 vote267 views1 answer
How to git pull all projects in a folder
TypeScript

Share