/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 vote131 views6 answers
How to add typescript tp create react app
TypeScript
7 votes177 views2 answers
Sort array of objects in react js
TypeScript
4 votes139 views2 answers
Cannot find module .svg' or its corresponding type declarations.
TypeScript
6 votes136 views1 answer
File C:\Users\SHUBHAM KUNWAR\AppData\Roaming\npm\nodemon.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
1 vote144 views1 answer
Vue textarea autosize
TypeScript
1 vote167 views2 answers
No type arguments expected for interface ListAdapter
TypeScript
7 votes240 views2 answers
React native typescript template
TypeScript
0 vote177 views1 answer
Typescript iterate over interface
TypeScript
0 vote143 views1 answer
How to combine pdf documents C#
TypeScript
0 vote137 views1 answer
How to print list contents in java
TypeScript

Share