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 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.