DataGrip sort more rows than page size

user_15905210 0
Viewed 34

In JetBrains DataGrip, when I try to sort a column (descending for example), it only shows and sorts loaded rows - that means 500 (it's the set page size). Is it possible that it can sort all rows (in my table like 25 000)?

I don't want to manually type order by column_name desc everytime I want to sort something.

In DBeaver this kind of sorting works.

datagrip jetbrains-ide sorting sql
1 Answers

You need to turn Sort via ORDER BY option on. So it will concat the ORDER BY for you.

enter image description here

Alternatively, you can always fetch all rows (use the corresponding setting) and client-based sorting will also sort all rows :)

enter image description here

user_57777990
Related