w3resource
SQL exercises

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

Syntax of select columns in different order

Pictorial presentation :

Result of select columns in different order

Query Visualization:

Duration:

Query visualization of Select columns in different order - Duration

Rows:

Query visualization of Select columns in different order - Rows

Cost:

Query visualization of Select columns in different order - 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