Question

Write a query to display the columns in a specific order like order date,​

Answer 1

Answer:

The order doesn't matter, actually, so you are free to order them however you'd like. edit: I guess a bit more background is helpful: As far as I know, the process of optimizing any query happens prior to determining exactly what subset of the row data is being pulled.

The SQL SELECT Statement

SELECT column1, column2, ... FROM table_name;

SELECT * FROM table_name;

Example. SELECT CustomerName, City FROM Customers;

Example. SELECT * FROM Customers

Answer 2

Answer:

ord_ no.

70001

purch_ amt

150.05

ord_ date

2012-10-05

customer_id

3005

salesman_id

5002