
SQL: Select columns in different order
SQL Basic Select Statement : Exercise-7 with Solution
Write a query to display salesman_id, salesman name, order date, order no, and purchase amount from orders table.
Sample table : ordersSample Solution :
SELECT ord_date, salesman_id, ord_no, purch_amt
FROM orders;
Output of the Query:
ord_date salesman_id ord_no purch_amt 2012-09-10 5005 70009 270.65 2012-10-05 5001 70002 65.26 2012-08-17 5003 70004 110.50 2012-07-27 5001 70005 2400.60 2012-09-10 5001 70008 5760.00 2012-10-10 5006 70010 1983.43 2012-10-10 5003 70003 2480.40 2012-08-17 5007 70011 75.29 2012-04-25 5001 70013 3045.60 2012-10-05 5002 70001 150.50 2012-09-10 5002 70007 948.50 2012-06-27 5002 70012 250.45
Explanation :

Pictorial presentation :

Query Visualization:
Duration:

Rows:

Cost:

Practice Online
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a query to display only name and commission from table salesman.
Next: Write a query which will retrieve the values of salesman id of all salesmen getting orders from the customers in orders table without any repeats.
What is the difficulty level of this exercise?
New Content: Composer: Dependency manager for PHP, R Programming