sortable

26 rows where pk1 = "d" sorted by sortable_with_nulls_2

descending

Link	pk1	pk2	content	sortable	sortable_with_nulls	sortable_with_nulls_2 ▼	text
d,v	d	v	d-v	76		0.2881048895936893	$null
d,s	d	s	d-s	98	0.5225725351302178	0.2973531325173874	$blah
d,p	d	p	d-p	-97	0.5740642196263323	0.34070593256029236	$blah
d,a	d	a	d-a	48	0.3119572443946952	0.37530695942531844	$null
d,i	d	i	d-i	42		0.40642812467051925	$null
d,d	d	d	d-d	-97		0.43352340132584843	$null
d,y	d	y	d-y	52	0.7489577220696233	0.4391534486737374	$blah
d,k	d	k	d-k	77	0.24330516387675716	0.47326048875952476	$blah
d,u	d	u	d-u	-33		0.551992245577759	$blah
d,g	d	g	d-g	15	0.46470846660323173	0.6681884704454936	$blah
d,o	d	o	d-o	-30	0.04551570098321833	0.6974173929101944	$null
d,t	d	t	d-t	45	0.6096309122451303	0.7627371043547087	$null
d,r	d	r	d-r	44		0.7644434453261942	$null
d,b	d	b	d-b	-81		0.772480884951224	$null
d,e	d	e	d-e	11	0.5217467469384799	0.8081992188067559	$blah
d,h	d	h	d-h	-54	0.48754993239134437	0.8803199797582254	$blah
d,z	d	z	d-z	-31		0.8894228892924536	$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)
);