/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 vote185 views2 answers
Css permit tabs on textarea react
TypeScript
0 vote225 views1 answer
Links a otros components angular
TypeScript
0 vote197 views1 answer
Google fonts icons size classes
TypeScript
0 vote203 views1 answer
Void main() { testWidgets('Counter increments smoke test', (WidgetTester tester) async { // Build our app and trigger a frame. await tester.pumpWidget(MyApp());
TypeScript
0 vote200 views1 answer
How many sets of 3 in 4
TypeScript
1 vote186 views2 answers
Ts lint ignore next line
TypeScript
6 votes212 views1 answer
An unhandled exception occurred: Cannot find module '@angular-devkit/build-angular/package.json' Require stack:
TypeScript
0 vote209 views1 answer
Correct this attempt to modify "product" or use "let" in its declaration. [+1 location]
TypeScript
0 vote202 views1 answer
Pdf viewer ionic 4
TypeScript
1 vote196 views2 answers
Ts-node command compile typescript
TypeScript

Share