/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 vote98 views1 answer
Can i use different flutter versions for differnt progjects ?
TypeScript
1 vote102 views1 answer
Can't bind to 'mat-dialog-close' since it isn't a known property of 'button'
TypeScript
0 vote105 views3 answers
Number to string typescript
TypeScript
1 vote112 views1 answer
File C:\Users\skill\AppData\Roaming\npm\yarn.ps1 cannot be loaded because running scripts is disabled on this system. For more information, see about_Execution_Policies at https:/go.microsoft.com/fwlink/?LinkID=135170.
TypeScript
32 votes110 views6 answers
Bootstrap alerts
TypeScript
0 vote129 views1 answer
An unhandled exception occurred: Schematic "Module" not found in collection "@schematics/angular".
TypeScript
0 vote92 views1 answer
Automation over manual testing
TypeScript
0 vote114 views1 answer
Cannot find module 'angular-imask' or its corresponding type declarations.
TypeScript
0 vote113 views1 answer
What types of Collections/Data structures you have used
TypeScript
2 votes117 views1 answer
Amcharts angular universal
TypeScript

Share