/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 vote139 views1 answer
C code for insrting elements in set
TypeScript
0 vote146 views1 answer
The html element that houses all html element that contains meta information about the web page,importing external stylesheets and internal ces
TypeScript
0 vote166 views1 answer
Error NG8001
TypeScript
0 vote132 views1 answer
How to search for imports in vscode
TypeScript
0 vote155 views1 answer
Depth-first search that chooses values for one variable at a time and returns when a variable has no legal values left to assign
TypeScript
0 vote141 views1 answer
Roblox how to weld parts together using script
TypeScript
0 vote139 views1 answer
Geodataframe from lat lon points python
TypeScript
0 vote138 views2 answers
Sorting a vector of objects c++
TypeScript
0 vote185 views1 answer
How many blocks are there in minecraft
TypeScript
6 votes159 views3 answers
Google sheets ifs
TypeScript

Share