/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

39 votes162 views5 answers
AppData\Roaming\npm\ng.ps1 cannot be loaded because running scripts is disabled on this system.
TypeScript
0 vote126 views1 answer
Java lambda list of objects cast
TypeScript
4 votes132 views2 answers
Hosts file
TypeScript
8 votes140 views2 answers
How to sort a list of objects python
TypeScript
4 votes162 views3 answers
Typescript get current timestamp
TypeScript
0 vote118 views1 answer
Does i5 7th generation processor supports windows 11
TypeScript
1 vote141 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
0 vote125 views1 answer
Angular elementref parent
TypeScript
0 vote108 views1 answer
You can initiate objects from a
TypeScript
0 vote118 views1 answer
How to search for imports in vscode
TypeScript

Share