From the following table, write a SQL query to find the details of those salespeople whose name starts with ‘N’ and the fourth character is 'l'

hamza

Save to bookmark

2022-05-18

335

From the following table, write a SQL query to find the details of those salespeople whose name starts with ‘N’ and the fourth character is 'l'. Rests may be any character. 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

ELECT *
FROM salesman
WHERE name LIKE 'N__l%';

Output of the Query:

salesman_id	name		city	commission
5002		Nail Knite	Paris	0.13

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 ‘N’ and the fourth character is 'l'

All Answers

Similar questions

need a help?

find thousands of online teachers now