/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 vote272 views1 answer
Aruments in C#
TypeScript
0 vote264 views1 answer
How many arguments does a call to the Math.sqrt method have?
TypeScript
24 votes286 views3 answers
Updates were rejected because a pushed branch tip is behind its remote
TypeScript
0 vote295 views1 answer
Install typescript homebrew
TypeScript
-1 vote275 views2 answers
Typescript initialize object
TypeScript
-1 vote256 views1 answer
.setRowHeights google script
TypeScript
0 vote290 views1 answer
Adding two lists using lambda function
TypeScript
0 vote280 views1 answer
Windows domain add hosts file
TypeScript
0 vote265 views1 answer
Omgsmhwthwhyomgnvm
TypeScript
0 vote268 views4 answers
Construct a binary tree from inorder and preorder traversal calculator
TypeScript

Share