/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 vote185 views1 answer
> [email protected] start > react-scripts start sh: react-scripts: command not found
TypeScript
2 votes202 views1 answer
Google Sheets How to Count business Days Between Two Dates
TypeScript
0 vote231 views1 answer
Delete attachments in nodejs
TypeScript
1 vote187 views2 answers
How to get all elements of column in pandas dataframe
TypeScript
0 vote189 views1 answer
React inherit html input props
TypeScript
2 votes228 views1 answer
Reactive forms get value of control
TypeScript
0 vote166 views1 answer
Common mistakes
TypeScript
0 vote170 views1 answer
Add active class when element exists into an array vuejs
TypeScript
0 vote183 views1 answer
How to use aspects in spring boot
TypeScript
0 vote183 views1 answer
Typescript webpack node
TypeScript

Share