/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 vote225 views1 answer
Do you use data structures in your current automation project
TypeScript
0 vote208 views1 answer
Laravel unique working with softdeletes
TypeScript
1 vote215 views1 answer
Typescript variable
TypeScript
0 vote214 views1 answer
Vulnerability of systems is divided into two (2) categories. List the two (2) categories.
TypeScript
2 votes204 views1 answer
How to install router in vue js
TypeScript
1 vote210 views1 answer
Set image on server with changing
TypeScript
1 vote207 views1 answer
Angular host binding class on input
TypeScript
2 votes214 views1 answer
How long does it take to learn typescript
TypeScript
0 vote242 views1 answer
Angular modal dismisss
TypeScript
2 votes219 views1 answer
Key value pairs typescript
TypeScript

Share