How to order a table withe the number of the columns with a specific value

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Hi, I hava a table like this.

ID   F01   F02   FO3
1    1     0     0
2    1     1     0
3    1     1     1

I Want the table reOrder like this

ID   F01   F02   FO3
3    1     1     1
2    1     1     0
1    1     0     0

Because the row 3, have 3, one in it's row.
row 2, have two, one in it's row.
and row1 have, the one , one in it's row.

Posted 17-Sep-14 22:07pm

FarshadSh

Updated 17-Sep-14 22:10pm

Aarti Meswania

v2

Add a Solution

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

hypermellow · Answer 1 · 2014-09-17T22:12:00

Solution 1

Hi,

You should be able to achieve your desired order by specifying multiple columns in the order by clause.

SQL

SELECT
 ID,F01,F02,F03
FROM
 tblData
ORDER BY
 ID DESC, 
 F01 DESC, 
 F02 DESC, 
 F03 DESC

Posted 17-Sep-14 22:12pm

hypermellow

Aarti Meswania · Answer 2 · 2014-09-17T22:15:00

Solution 2

Try this...

SQL

select * from tablename
Order by F01 desc, F02 desc, FO3 desc

Happy Coding! :)

Posted 17-Sep-14 22:15pm

Aarti Meswania

Magic Wonder · Answer 3 · 2014-09-17T22:18:00

Solution 3

Hi,

Check this...

SQL

SELECT * FROM your_Table order by 2 desc, 3 desc, 4 desc

i have not considered id as prime factor. Gave focus on values.

Also go through this..Order By[^]

Hope this will help you.

Cheers

Posted 17-Sep-14 22:18pm

Magic Wonder

Updated 17-Sep-14 22:19pm

v2

Comments

FarshadSh 19-Sep-14 11:24am

i want the row3 become to row 1. becuse it have 3, one in it's row.

Magic Wonder 22-Sep-14 1:43am

If you have this much of data in your table then use id for sorting in order by clause...like order by 1 desc, 2 desc, 3 desc, 4 desc....

In above query i assumed that your F01,F02,F03 should come w.r.t. values available in your data.