Please note, this is a STATIC archive of website www.w3resource.com from 19 Jul 2022, cach3.com does not collect or store any user information, there is no "phishing" involved.
w3resource

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

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

Test your Programming skills with w3resource's quiz.

What is the difficulty level of this exercise?



SQL: Tips of the Day

SQL Server SELECT into existing table. 

INSERT INTO dbo.TABLETWO
SELECT col1, col2
  FROM dbo.TABLEONE
 WHERE col3 LIKE @search_key

This assumes there's only two columns in dbo.TABLETWO - you need to specify the columns otherwise:

INSERT INTO dbo.TABLETWO
  (col1, col2)
SELECT col1, col2
  FROM dbo.TABLEONE
 WHERE col3 LIKE @search_key

Database: SQL Server

Ref: https://bit.ly/3y6tpA3