/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

2 votes144 views2 answers
Get last elements of list python
TypeScript
2 votes131 views2 answers
Change material ui appbar color
TypeScript
0 vote128 views1 answer
How to check that tuple contains unique elements
TypeScript
0 vote134 views1 answer
Module svg typescript
TypeScript
0 vote127 views1 answer
Change event doesn't work on dynamically generated elements .
TypeScript
0 vote138 views1 answer
Interface with variable key typescript
TypeScript
0 vote142 views1 answer
React native typescript template not working
TypeScript
0 vote130 views1 answer
Window ethereum types
TypeScript
0 vote167 views1 answer
After effects how to parent only one property
TypeScript
0 vote130 views1 answer
Pass parameter to NestJs Guard
TypeScript

Share