how to return column data in reverse order in a table in sqlserver

Question

1.00/5 (2 votes)

See more:

SQL-Server-2008

hai

i have table and in that only one column
the column data is
col1
1
0
1
0

so here i want to present the data in reverse order of col1 is like below
col1
o
1
0
1

how many ways are there to return result above order and how can we return?
please give me answer to this question....

Posted 15-Jun-13 2:08am

Madhu from Bangalore

Add a Solution

1 solution

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)

**Zoltán Zörgő** · Answer 1 · 2013-06-15T02:29:00

Solution 1

And what is the order logic in the first case? What is the ordering key? Use it in with DESC! If it is the natural order of inserting the data, you should use an autoincrement field or a timestamp and us that field when selecting. A table is not an excel sheet.
Still, although the answer to your original question should not be used, it exists:

SQL

select * from
    (select ROW_NUMBER() OVER (ORDER BY (SELECT 1)) RowNumber ,* from sys.databases) TMP
order by RowNumber desc

Replace the underlined part with your query. This is the general approach, but represent an unnecessary overhead in most cases. You should review your model.

Posted 15-Jun-13 2:29am

Zoltán Zörgő

Comments

Madhu from Bangalore 15-Jun-13 9:21am

thank you
but here in the order by clause having (select 1)
what is that meaning

Zoltán Zörgő 15-Jun-13 13:58pm

Yes, because you did not specify any other order. There is no natural ordering that gives you 1,0,1,0. So you probably have some other logic you kept for yourself. This order by clause is only used because ROW_NUMBER is needing one, and I needed ROW_NUMBER to reverse it. But if you have your ORDER BY clause in your query (you could have posted here), you can simply use DESC-

Madhu from Bangalore 16-Jun-13 2:30am

Thank you for your response.
I am new to SQL Server . now i am in learning stage
the above table is simple table i created and there is no keys and orders like DESC and ASC.
so give me how many ways are there to return reverse order like 0101.
and you mentioned in order by clause is "(select 1)" what is that purpose?
please give brief informatin

Zoltán Zörgő 16-Jun-13 14:35pm

I already described it: ROW_NUMBER needs an order by clause, and because there is no other ordering, I have used SELECT 1. If you have no other ordering you can use this, and reverse it as I did. Only a concrete order can be reversed - be aware, that the table is a set of rows. A set is unsorted. If you don't specify any ordering in your query nobody will guarantee that the order will be the same next time also.