From the following table, write a SQL query to find the details of those salespeople whose name starts with any letter within 'A' and 'L'

hamza

Save to bookmark

2022-05-18

133

From the following table, write a SQL query to find the details of those salespeople whose name starts with any letter within 'A' and 'L' (not inclusive). Return salesman_id, name, city, commission.

Sample table: salesman

salesman_id |    name    |   city   | commission 
-------------+------------+----------+------------
        5001 | James Hoog | New York |       0.15
        5002 | Nail Knite | Paris    |       0.13
        5005 | Pit Alex   | London   |       0.11
        5006 | Mc Lyon    | Paris    |       0.14
        5007 | Paul Adam  | Rome     |       0.13
        5003 | Lauson Hen | San Jose |       0.12

Sql programming,

All Answers

hamza

2022-05-18

need an explanation for this answer? contact us directly to get an explanation for this answer

SELECT *
FROM salesman
WHERE name BETWEEN 'A' and 'L';

Output of the Query:

salesman_id	name		city		commission
5001		James Hoog	New York	0.15

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

From the following table, write a SQL query to find the details of those salespeople whose name starts with any letter within 'A' and 'L'

All Answers

Similar questions

need a help?

find thousands of online teachers now