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

Question

i want to display the employee names which having names start with a and b  it should be like list will display employees with   a  as a first letter and then the   b  as a first letter     so any body tell me what is the command to display these

User · Answer

select columns   from table  where            column like  a          or column like  b      order by column asc

User · Answer

select employee name  from employees where employee name LIKE  A   OR employee name LIKE  B   order by employee name

User · Answer

Here what I understood from the question is starting with  a   and then  b  ex    abhay abhishek abhinav   So there should be two conditions and both should be true means you cant use  OR  operator Ordered by is not not compulsory but its good if you use   Select e name from emp  where  e name like  a   AND e name like   b   Ordered by e name

User · Answer

select name last  name first from employees where name last like  A   or name last like  B   order by name last  name first asc

User · Answer

We can also use REGEXP  select employee name  from employees where employee name REGEXP   ab     order by employee name

User · Answer

select    from stores  where name like  a   or  name like  b    order by name

User · Answer

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 is not standard SQL though it just gets translated to the following which is   WHERE  employee name  gt    A         AND employee name  lt   C     For all variants you would need to consider whether you want to include accented variants such as    and test whether the queries above do what you want with these on your RDBMS and collation options

User · Answer

If you re asking about alphabetical order the syntax is   SELECT   FROM table ORDER BY column   the best example I can give without knowing your table and field names   SELECT   FROM employees ORDER BY name

User · Answer

Regular expressions work well if needing to find a range of starting characters   The following finds all employee names starting with A  B  C or D and adds the    UPPER    call in case a name is in the database with a starting lowercase letter   My query works in Oracle  I did not test other DB s    The following would return for example  Adams adams Dean dean  This query also ignores case in the ORDER BY via the  lower  call   SELECT employee name  FROM employees WHERE REGEXP LIKE UPPER TRIM employee name       A-D    ORDER BY lower employee name

User · Answer

Oracle  Just felt to do it in different way  Disadvantage  It doesn t perform full index scan  But still gives the result and can use this in substring   select employee name  from employees where lpad employee name 1    A   OR lpad employee name 1     B  order by employee name   We can use LEFT in SQL Server  instead of lpad   Still suggest not a good idea to use this method

User · Answer

What cfengineers said  except it sounds like you will want to sort it as well     select columns   from table  where            column like  a          or column like  b     order by column   Perhaps it would be a good idea for you to check out some tutorials on SQL  it s pretty interesting

User · Answer

From A to Z    select employee name from employees ORDER BY employee name     From Z to A   select employee name from employees ORDER BY employee name desc

[sql] how to display employee names starting with a and then b in sql

Examples related to sql