How to sort in SQL?

Question

PostgreSQL

Hey! I have a table:

id	count	to	status	user_id	created_at	updated_at
one	500	0	0	one	2015-02-18 13:54:44.912000	2015-02-18 12:54:47.328000
2	400	0	2	one	2015-02-18 14:04:51.700000	2015-02-18 14:04:53.487000

Where status takes the values ​​0, 1, 2...n
I need to sort in such a way that first there are rows where satatus == 0, and then all the rest (which should no longer be sorted by status). I also need all rows to be sorted by the upadted_at, desc field.
Ideally, of course, ALL fields should be displayed where status = 0, and, also, if they turned out to be < 50, then we supplement up to 50 with the remaining lines. And if there are more of them, then we do not display fields where the status is not 0.
Any ideas how to implement this? :)

Answer 1

Use CASE:
select status,
case
when status = 0 then
0
else
1
end as status_tmp ,
updated_at
from your_table t
order by status_tmp , updated_at
desc I use Oracle, but I know CASE is also in PostgreSQL. And it is better to implement checks for the number of lines and the actions following them in a stored procedure.

Answer 2

you need to add a new field of type select IF(status>0,1,0) status1 to the select
and then order by status1, updated_at DESC

Answer 3

ORDER BY status, upadted_at - won't work?

Answer 4

... ORDER BY status, updated_at DESC