order by column number?

Tags:
SQL
Can you order by a column number, if so, what's the syntax?

Answer Wiki

Thanks. We'll let you know when a new response is added.

If you are using SQL, you can order by the column position of the returned set.

EG., the statement:
SELECT Something, SomethingElse
FROM MyTable
ORDER BY 1

<b>NOTE:</b> THE POSITION OF THE COLUMN IS THE POSITION IN THE PROJECTION LIST
BUT NOT IN THE PHYSICAL TABLE

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • SloopJohnB
    If you are using SQL, you can order by the column position of the returned set. EG., the statement: SELECT Something, SomethingElse FROM MyTable ORDER BY 1 Will order by the Something column. If you are doing a Select *, then the number will refer to the column position in the returned table.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following