SQL: Select columns in different order

SQL Basic Select Statement: Exercise-7 with Solution

Write a query to display the columns in a specific order, such as order date, salesman ID, order number, and purchase amount for all orders.

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 :

Practice Online

Query Visualization:

Duration:

Rows:

Cost:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a SQL statement to display specific columns like name and commission for all the salesmen.
Next: From the following table, write a SQL query to find the unique salespeople ID. Return salesman_id.