L statement to make a list in ascending order for the customer who works either

Question

L statement to make a list in ascending order for the customer who works either write a SQOL to through a salesman or by o wn. Sample table: customer er id cust_name customer_id salesman_id city grade 3002 3005 3001 3004 3007 3009 3008 3003 Nick Rimando New York 100 Graham Zusi California 200 Brad Guzan London Fabian Johns Paris Brad Davis New York 200 Geoff Camero Berlin Julian Green London Jozy Altidor Moscow 5001 5002 5005 5006 5001 5003 300 300 5002 5007 Sample table: salesman salesman id name city commission 5001 5002 5005 5006 5003 5007 James Hoog New York 0.15 Nail Knite Paris Pit Alex London Mc Lyon Lauson Hen Paul Adam Rome 0.13 0.11 0.14 0.12 Paris

Explanation / Answer

Answer is as follows:

SELECT * FROM Customers ORDER BY Customer_id ASC;

The above sql statement will set the table customer in ascending order according to their unique Id i.e. Customer_id even then they works through salesman or own.

SELECT * FROM Salesman ORDER BY Salesman_id ASC;

if there is any query please ask in comments...

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.