/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 vote209 views1 answer
Write a C proogram to find the roots of quadratic equation
TypeScript
0 vote180 views1 answer
How to set value of multiselect dropdown for reactive forms in angular 6
TypeScript
1 vote175 views1 answer
Axios multiple request
TypeScript
1 vote167 views2 answers
React-scripts
TypeScript
0 vote183 views1 answer
I like
TypeScript
1 vote159 views1 answer
Why does mongoose minimize by default
TypeScript
0 vote169 views1 answer
How to remove duplcates elements from arraylist
TypeScript
8 votes197 views2 answers
Comment on blade laravel
TypeScript
1 vote240 views1 answer
Cannot find module 'file-saver/FileSaver' or its corresponding type declarations.
TypeScript
0 vote171 views1 answer
"Listed following are distinguishing characteristics of different end states of stars. Match these to the appropriate consequence of stellar death."
TypeScript

Share