how to order field in table according to own needs

Question

3.00/5 (1 vote)

See more:

in a table i have six row but the order of rows are not according to my needs. i want to order those row by my needs. how can i do this

Posted 30-Sep-13 19:34pm

Muhamad Faizan Khan

Add a Solution

Comments

Azee 1-Oct-13 1:39am

By " order those row by my needs" do you mean in a Select statement?

Muhamad Faizan Khan 1-Oct-13 1:54am

no in database. in select we can use order by clause. But i want to order in table

Azee 1-Oct-13 1:57am

So you are saying you want to change the order by which the rows are saved in the database table? and why does that even matter when you can order them anyway you want in your queries?

Muhamad Faizan Khan 1-Oct-13 2:07am

ok how to do it?? in query i only know about ascedning and descending order

Azee 1-Oct-13 2:09am

Hey, I am asking why do you need to do that when you can do sorting in the query? Give me a good reason then I'll suggest a solution.

Muhamad Faizan Khan 1-Oct-13 2:13am

i don't know how to order table according to the my needs. I am only know how to order in ascending or descending. Thats why i asked

Azee 1-Oct-13 2:21am

Sorry, I couldn't understand your question. Check the example below.

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)

Amol_B · Answer 1 · 2013-09-30T20:35:00

You can use order by clause to order data as per your needs.
If you want record to be stored in specific order then it cant be done as record are inserted in database as first come first serve basis. And even if records are stored in any order in database you can always 'Order By. your queries and views.

**Azee** · Answer 2 · 2013-09-30T20:17:00

Solution 1

Here:

Check this example and let me know if it doesn't clear your concept:

http://www.w3schools.com/sql/sql_orderby.asp[^]

If you have issue ordering in a specific Sql query, then post it, I'll take a look.

Azee...

Posted 30-Sep-13 20:17pm

Azee

Updated 30-Sep-13 20:18pm

v2