/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 vote144 views1 answer
Split in angular 8
TypeScript
0 vote157 views2 answers
Serve images in nextgen formats webp
TypeScript
18 votes146 views3 answers
What is unit testing
TypeScript
5 votes259 views1 answer
Sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread
TypeScript
0 vote142 views1 answer
Filename requests python
TypeScript
0 vote211 views1 answer
React dynamic inputs with id
TypeScript
0 vote145 views2 answers
Sorting a vector of objects c++
TypeScript
0 vote141 views1 answer
Network analysis projects code python graph and histogram with data facbook
TypeScript
4 votes156 views3 answers
Show timestamp as yyyy mm dd html angular
TypeScript
6 votes143 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

Share