/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 vote148 views1 answer
Send tcp packets to kubernetes node
TypeScript
16 votes160 views6 answers
Create react native app typescript
TypeScript
0 vote144 views1 answer
Typeorm @unique
TypeScript
0 vote140 views2 answers
When should you stop testing
TypeScript
0 vote147 views1 answer
Google sheets script save A RANGE to csv
TypeScript
0 vote143 views1 answer
Difference known_hosts authorized_keys
TypeScript
1 vote132 views1 answer
> [email protected] start > react-scripts start sh: react-scripts: command not found
TypeScript
3 votes131 views3 answers
Squash commits on branch
TypeScript
0 vote136 views1 answer
View and navigate your assignments (teacher) code for asp.net
TypeScript
5 votes133 views1 answer
Extends vs implements java
TypeScript

Share