/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 vote154 views1 answer
C# get all elements from list
TypeScript
0 vote235 views1 answer
The pipe 'json' could not be found!
TypeScript
0 vote163 views2 answers
Modify objects using dot notation
TypeScript
1 vote177 views1 answer
Mysqli_select_db expects 2 parameters
TypeScript
1 vote203 views1 answer
Activate virtualenv scripts
TypeScript
0 vote167 views1 answer
Onblur vs valuechange
TypeScript
0 vote157 views1 answer
Angular cancel http request
TypeScript
0 vote166 views1 answer
Sockjs-node/info?t=net::ERR_CONNECTION_TIMED_OUT
TypeScript
0 vote161 views1 answer
Open url with pacage.json
TypeScript
0 vote168 views1 answer
Get number of objects in enum c++
TypeScript

Share