w3resource

SQL Exercises: 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 table : orders

ord_no      purch_amt   ord_date    customer_id  salesman_id
----------  ----------  ----------  -----------  -----------
70001       150.5       2012-10-05  3005         5002
70009       270.65      2012-09-10  3001         5005
70002       65.26       2012-10-05  3002         5001
70004       110.5       2012-08-17  3009         5003
70007       948.5       2012-09-10  3005         5002
70005       2400.6      2012-07-27  3007         5001
70008       5760        2012-09-10  3002         5001
70010       1983.43     2012-10-10  3004         5006
70003       2480.4      2012-10-10  3009         5003
70012       250.45      2012-06-27  3008         5002
70011       75.29       2012-08-17  3003         5007
70013       3045.6      2012-04-25  3002         5001

Sample Solution :

-- This query selects specific columns 'ord_date', 'salesman_id', 'ord_no', and 'purch_amt' from the 'orders' table.
SELECT ord_date, salesman_id, ord_no, purch_amt
-- Specifies the table from which to retrieve the data (in this case, 'orders').
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

Code Explanation :

The above query in SQL that selects the "ord_date", "salesman_id", "ord_no" and "purch_amt" columns from the 'orders' table. It returns all the rows of the specified columns.

Syntax of select columns in different order

Visual presentation:

Result of select columns in different order

Practice Online


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

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

Previous SQL Exercise: Select specific columns from a table.
Next SQL Exercise: Identify distinct values in a table.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



Follow us on Facebook and Twitter for latest update.