/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 vote315 views1 answer
Ngx-numeral
TypeScript
0 vote308 views1 answer
Coldfusion check if key exists and not empty
TypeScript
-1 vote305 views1 answer
What are the components of the environment? Explain it along with the examples.
TypeScript
0 vote391 views1 answer
Expected 1 arguments, but got 0. Did you forget to include 'void' in your type argument to 'Promise'?
TypeScript
0 vote331 views1 answer
Beyondcode/laravel-websockets 1.12.0 requires pusher/pusher-php-server ^3.0|^4.0|^5.0 -> found pusher/pusher-php-server[dev-master
TypeScript
0 vote347 views1 answer
Vertical dots latex
TypeScript
2 votes313 views1 answer
NotificationManager has not been initialized
TypeScript
0 vote313 views1 answer
Material ui tab link external
TypeScript
0 vote313 views1 answer
Google places auto-complete
TypeScript
0 vote307 views1 answer
Input deno
TypeScript

Share