/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 vote117 views1 answer
Display Popular Posts laravel
TypeScript
0 vote103 views1 answer
Vscode use relative paths in auto import
TypeScript
1 vote113 views2 answers
Verify if object is of a certain type type in typescript
TypeScript
12 votes99 views6 answers
Typescript array of objects
TypeScript
0 vote115 views1 answer
Typescript utility types merge interfaces
TypeScript
0 vote109 views1 answer
Sap abap check file exists on application server tcode
TypeScript
0 vote117 views1 answer
The Apple I had a built-in video terminal, sockets for __________ kilobytes of onboard random access memory (RAM), a keyboard, and a cassette board meant to work with regular cassette recorders.
TypeScript
0 vote100 views1 answer
Benefits of waxing body hair
TypeScript
0 vote112 views1 answer
Tell me about your Automation strategy of manual test cases
TypeScript
0 vote98 views1 answer
"What do the observed locations of gamma-ray bursts tell us about them?"
TypeScript

Share