/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

1 vote118 views1 answer
Display digital clock in angular
TypeScript
0 vote110 views1 answer
Generator typescript
TypeScript
0 vote112 views1 answer
Choose random elements from vector without repetition and adding to another vector c++
TypeScript
0 vote114 views1 answer
Permalink of pending posts not working
TypeScript
0 vote118 views1 answer
Cannot find name 'describe'. Do you need to install type definitions for a test runner? Try `npm i --save-dev @types/jest`
TypeScript
0 vote163 views1 answer
Express typescript error handling
TypeScript
0 vote137 views1 answer
Length in typescript
TypeScript
0 vote147 views1 answer
Angular tokenize
TypeScript
-2 votes119 views1 answer
Typescript operate with html objects
TypeScript
1 vote121 views1 answer
React-router-dom redirect on click
TypeScript

Share