/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 vote198 views1 answer
Deno router
TypeScript
-1 vote226 views1 answer
Lua table to string
TypeScript
12 votes231 views3 answers
Loop through string js
TypeScript
19 votes220 views3 answers
Random between two floats python
TypeScript
0 vote220 views1 answer
Function that takes first & last name and then it greets the user using his full name.
TypeScript
0 vote228 views1 answer
Typescript instantiate 2d array
TypeScript
0 vote240 views1 answer
Selenium components
TypeScript
-1 vote228 views1 answer
What is http request made of
TypeScript
0 vote228 views1 answer
Roblox how to weld parts together using script
TypeScript
0 vote219 views1 answer
The dialect mongodb+srv is not supported. Supported dialects feathers
TypeScript

Share