How to segment sort in sql access

Question

0.00/5 (No votes)

See more:

Hello dear,
Can u help me, please.
I have a Table in Ms Access contain data like this
ID Name
1 Dara
2 Somi
3 Vicheka
4 Sokun
5 Chann
6 Rith
7 Kaka
8 Nyla
9 sun
10 Lolana

I want to sort like this in Query or SQL Code, ...
3 Vicheka
2 Somi
1 Dara
6 Rith
5 Chann
4 Sokun
9 sun
8 Nyla
7 Kaka
10 Lolana

Can you help me do like below?
I waiting for result from all dear.

Posted 29-Sep-15 16:11pm

savin phat

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)

Gustav Brock · Answer 1 · 2015-09-30T00:38:00

Solution 2

Yes you can:

SQL

SELECT 
    ID, [Name]
FROM 
    tblYourTable
ORDER BY 
    ([ID]-1) \ 3, ID DESC;

Note the backslash for integer division.

Posted 30-Sep-15 0:38am

Gustav Brock

Comments

Maciej Los 30-Sep-15 7:18am

5ed!

savin phat 1-Oct-15 2:24am

Thank you sir

savin phat 1-Oct-15 2:30am

mean the same question and sort like above, if I change ID to 4 digit
ID Name
1001 Dara
1002 Somi
1003 Vicheka
1004 Sokun
1005 Chann
1006 Rith
1007 Kaka
1008 Nyla
1009 sun
1010 Lolana
Help me please.
Thank q befor sir.

Gustav Brock 1-Oct-15 3:04am

That would be:

SELECT
ID, [Name]
FROM
tblYourTable
ORDER BY
([ID]-2) \ 3, ID DESC;

Adjust the subtrahend between 0 and 2 to control the sequence.

phil.o · Answer 2 · 2015-09-29T18:55:00

Solution 1

As there is no sorting to do (the order you need cannot be expressed with comparison operators), you have to add a third column to your table, named for example OrderNumber, where you will put the index of the line in which you want it to appear.
Then, in your query, you just have to add a ORDER BY clause on the new column.

Posted 29-Sep-15 18:55pm

phil.o

Comments

Krunal Rohit 30-Sep-15 1:05am

Yeah.

-KR