sortable

26 rows where pk1 = "d" sorted by sortable_with_nulls_2 descending

descending

Link	pk1	pk2	content	sortable	sortable_with_nulls	sortable_with_nulls_2 ▲	text
d,l	d	l	d-l	-10	0.7028549421857689	0.23053804129850775	$null
d,m	d	m	d-m	90		0.19154097301054474	$blah
d,c	d	c	d-c	44	0.7826353463610196	0.06895673651964052	$blah
d,n	d	n	d-n	-75	0.8326283633270679	0.014148367256063832	$null
d,f	d	f	d-f	19	0.4355744930038943		$blah
d,j	d	j	d-j	76	0.4760931107841647		$blah
d,q	d	q	d-q	-71			$null
d,w	d	w	d-w	75	0.26455462565889964		$blah
d,x	d	x	d-x	-71	0.5445623787105787		$blah

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE sortable (
  pk1 varchar(30),
  pk2 varchar(30),
  content text,
  sortable integer,
  sortable_with_nulls real,
  sortable_with_nulls_2 real,
  text text,
  PRIMARY KEY (pk1, pk2)
);