/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 vote188 views1 answer
Event
TypeScript
0 vote149 views1 answer
Typescript declare "userLanguage"
TypeScript
3 votes149 views1 answer
Typescript string contains
TypeScript
0 vote154 views1 answer
Separate subplots in python
TypeScript
0 vote150 views1 answer
Import validator adonisjs 5
TypeScript
1 vote158 views1 answer
Regex ts
TypeScript
0 vote155 views1 answer
The react-scripts package provided by Create React App requires a dependency: [1] [1] "webpack": "4.42.0"
TypeScript
2 votes149 views2 answers
Length array angular
TypeScript
0 vote156 views1 answer
Wordpress get_posts custom posts by meta key
TypeScript
0 vote150 views1 answer
Google charts haxis font size
TypeScript

Share