Sorting the data by ascending order by all columns in a table

Question

0.00/5 (No votes)

See more:

is it possible to use order by column name for more than 1 column in a sql database? i mean can we use order by column combining more than one column in a sql. like order by column A and column B.

Posted 12-Aug-13 0:50am

ARUN K P

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sudhakar Shinde · Accepted Answer · 2013-08-12T01:04:00

Solution 1

Very much possible. Following is syntax for SELECT statement where multiple columns are used in ORDER BY clause.

SQL

SELECT column_name1, column_name2
FROM table_name
ORDER BY column_name1 ASC|DESC, column_name2 ASC|DESC;

ASC|DESC meaning you can use either of them.

Posted 12-Aug-13 1:04am

Sudhakar Shinde

Updated 12-Aug-13 1:16am

v2

Comments

Adarsh chauhan 12-Aug-13 7:15am

+5

Maciej Los 12-Aug-13 7:17am

Agree.
+5!

ARUN K P 12-Aug-13 7:17am

ok thank you
+5

Maciej Los 12-Aug-13 7:18am

Arun, please, mark all useful answers as a solution (green button) to remove your question from unanswered list.

ARUN K P 12-Aug-13 7:22am

u mean i have to click accept solution button right?

Maciej Los 12-Aug-13 7:26am

Yes. I see that you have done it yet. Thanks!

ARUN K P 12-Aug-13 7:27am

Welcome maciej :) and thanks

Maciej Los · Accepted Answer · 2013-08-12T01:16:00

Solution 2

Yes, it is possible. Please, see here: ORDER BY Clause (T-SQL)[^]

Posted 12-Aug-13 1:16am

Maciej Los

Comments

ARUN K P 12-Aug-13 7:17am

+5

Maciej Los 12-Aug-13 7:19am

Thank you.
Have you seen my comment to the solution 1?

Adarsh chauhan 12-Aug-13 7:20am

+5 from me also.. :)

Maciej Los 12-Aug-13 7:26am

Thank you ;)

ARUN K P 12-Aug-13 7:22am

yeah maciej los thanks :)

Maciej Los 12-Aug-13 7:26am

Thank you ;)