/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 vote143 views1 answer
Clinical thermometer consists of a long, narrow, uniformclinical thermometer consists of a long, narrow, uniform
TypeScript
0 vote139 views1 answer
Style type in typescript in react
TypeScript
0 vote125 views1 answer
Delete the last string from file in typescript
TypeScript
0 vote139 views1 answer
None of the following functions can be called with the arguments supplied. makeText(Context!, CharSequence!, Int) defined in android.widget.Toast makeText(Context!, Int, Int) defined in android.widget.Toast
TypeScript
0 vote130 views1 answer
Export const typescript
TypeScript
0 vote128 views1 answer
Function in c that converts current time in timezone
TypeScript
52 votes284 views6 answers
Length of an array javascript
TypeScript
0 vote117 views1 answer
Typescript allow object subset of interface
TypeScript
7 votes126 views2 answers
Firestore increment field
TypeScript
0 vote142 views2 answers
Module '"@angular/fire"' has no exported member 'AngularFirestore'
TypeScript

Share