Sort SQL by value

Question

I have data like this:

Customer ID	Name	Type	Last Submit
1	Patricio	C	January 2022
2	Dale	A	June 2022
3	Yvonne	C	July 2022
4	Pawe	C	JUne 2022
5	Sergio	B	August 2022
6	Roland	C	August 2022
7	Georg	D	November 2022
8	Catherine	D	October 2022
9	Pascale	E	October 2022
10	Irene	A	November 2022

How to sort type A out of the queue first like A,B,C,D,E,F, then the last submit is at the top.

The example output:

Customer ID	Name	Type	Last Submit
10	Irene	A	November 202[![enter image description here][1]][1]2
1	Dale	A	June 2022
5	Sergio	B	August 2022
6	Roland	C	August 2022
3	Yvonne	C	July 2022
4	Pawe	C	June 2022
1	Patricio	C	January 2022
7	Georg	D	November 2022
8	Catherine	D	October 2022
9	Pascale	E	October 2022

What data type is column `Last submit` - if this is actually a *date* it should not be a *string*. — Stu, Nov 10 '22 at 12:11

Stefan Stroe · Accepted Answer · 2022-11-10T12:04:39.397

0

So basically you want to sort by 2 different columns, this is detailed in this other answer: SQL multiple column ordering

In your example you would do

ORDER BY type, last_submit

edited Nov 10 '22 at 12:04

answered Nov 10 '22 at 12:03

Stefan Stroe

Note that last_submit doesn't work when month names aren't in alphabetical order. – jarlh Nov 10 '22 at 12:07
good catch @jarlh ! I assumed that the column would be a timestamp – Stefan Stroe Nov 10 '22 at 12:31
how about sorting like b, c, d, a, e? – – dimas tatag anditya Nov 11 '22 at 08:48
what are you trying to achieve with this? Just a custom sort? – Stefan Stroe Nov 17 '22 at 15:18

score 0 · Answer 2 · answered Nov 10 '22 at 12:05

0

Hi you can use simple order by in postgresql like this

SELECT
     *
FROM
    table (your table name)
ORDER BY
    type ASC, last_submit DESC;

answered Nov 10 '22 at 12:05

muhammad saad

how about sorting like b, c, d, a, e? – – dimas tatag anditya Nov 11 '22 at 08:48
b, c, d,a,e is not sorted version of the list – muhammad saad Nov 11 '22 at 09:39

score 0 · Answer 3 · answered Nov 10 '22 at 12:12

0

In this case, you need to sort your query using the two columns in order.

Add this part to the end of your query.

ORDER BY type, last_submit DESC;

answered Nov 10 '22 at 12:12

AbdusSalam

how about sorting like b, c, d, a, e? – dimas tatag anditya Nov 11 '22 at 04:00
This is not sorting I did not see a connection in this sorting; This is an arbitrary result unless you have another relation between them that could result in such an order – AbdusSalam Nov 12 '22 at 10:29

score 0 · Answer 4 · edited Jul 20 '23 at 12:57

0

This code should get you your desired output.

SELECT 
     customer_ID,
     Name,
     Type,
     Last_Submit
FROM 
     [schema name].[your table name]
ORDER BY 
     Type ASC, Last_Submit DESC

edited Jul 20 '23 at 12:57

helvete

answered Jul 16 '23 at 12:09

Aniket

4 Answers4