programming-examples/Write a sql query to display the order number followed by order date and the purchase amount for each order which will be delivered by the salesman who is holding the ID 5001.sql at master - programming-examples - michuIT: Everything is code

You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

5 lines

260 B

SQL

Raw Permalink Blame History

 /*Write a sql query to display the order number followed by order date and the purchase amount for each order which will
  be delivered by the salesman who is holding the ID 5001.*/
  SELECT ord_no, ord_date, purch_amt
 FROM orders
 WHERE salesman_id=5001;