How to display employee names starting with a and then b in sql

Question

I want to display the names of the employees whose first letters begin with the letters a and b. The list should show the names of the employees whose first letter is 'a' before moving on to 'b'.

Thus if anyone knows the command to display these, please let me know.

Answer 1

To get employee names starting with A or B listed in order: 

select employee_name 
from employees
where employee_name LIKE 'A%' OR employee_name LIKE 'B%'
order by employee_name

If you are using Microsoft SQL Server you could use: 

....
where employee_name  LIKE '[A-B]%'
order by employee_name

This isn't standard SQL however it simply gets meant the accompanying which is.

WHERE  employee_name >= 'A'
       AND employee_name < 'C' 

For all variations you would have to consider whether you need to incorporate highlighted variations, for example, Á and test whether the questions above do what you need with these on your RDBMS and examination choices.

I hope this helps you.

Answer 2

I hope this will help.

select * from Employees where Name like '[ab]%'