sortable

94 rows where text = "$blah" sorted by sortable_with_nulls_2

descending

Link	pk1	pk2	content	sortable	sortable_with_nulls	sortable_with_nulls_2 ▼	text
g,j	g	j	g-j	-87		0.27210284354621894	$blah
c,v	c	v	c-v	16	0.32684580488130854	0.278256615638806	$blah
d,s	d	s	d-s	98	0.5225725351302178	0.2973531325173874	$blah
a,k	a	k	a-k	-32	0.913136124185545	0.3146778807984779	$blah
d,p	d	p	d-p	-97	0.5740642196263323	0.34070593256029236	$blah
g,c	g	c	g-c	50	0.5616833815697281	0.35359807963376766	$blah
f,x	f	x	f-x	59	0.6330767243010155	0.3809043988185208	$blah
b,k	b	k	b-k	-48	0.6697259747698292	0.3957858467912545	$blah
e,g	e	g	e-g	94		0.43811609507237825	$blah
d,y	d	y	d-y	52	0.7489577220696233	0.4391534486737374	$blah
f,d	f	d	f-d	60		0.4408231901628116	$blah
b,r	b	r	b-r	-100	0.33355653860508816	0.44183551186085057	$blah
e,m	e	m	e-m	50		0.44654739304319446	$blah
h,l	h	l	h-l	-6	0.6783068250650924	0.4616799784409892	$blah
d,k	d	k	d-k	77	0.24330516387675716	0.47326048875952476	$blah
b,y	b	y	b-y	-29	0.8643529420302863	0.5094056755280374	$blah
h,a	h	a	h-a	-90	0.24774372359828423	0.5240685531701745	$blah
f,t	f	t	f-t	-56	0.26536750832497336	0.5260855265978671	$blah
b,g	b	g	b-g	-61		0.5421952013742742	$blah
d,u	d	u	d-u	-33		0.551992245577759	$blah
c,l	c	l	c-l	-66	0.6675777325863531	0.5954523184694197	$blah
c,f	c	f	c-f	-23	0.4298881499898346	0.6066615704797627	$blah
h,d	h	d	h-d	-15	0.08150198744788395	0.6560547180360552	$blah
b,j	b	j	b-j	48	0.5945191535334412	0.6573731644725225	$blah
d,g	d	g	d-g	15	0.46470846660323173	0.6681884704454936	$blah
f,n	f	n	f-n	-45	0.44338308606070165	0.6856802654812854	$blah
e,r	e	r	e-r	20	0.2650227795434089	0.692704598586882	$blah
h,s	h	s	h-s	-80		0.7272347853249318	$blah
c,m	c	m	c-m	40	0.44591361207670044	0.7517767865005115	$blah
g,u	g	u	g-u	-55	0.9512921405795819	0.7544458252469858	$blah
h,b	h	b	h-b	-28	0.7744647885737355	0.7892269315636647	$blah
d,e	d	e	d-e	11	0.5217467469384799	0.8081992188067559	$blah
e,z	e	z	e-z	16	0.8453039251425987	0.8533354586601858	$blah
h,m	h	m	h-m	-59		0.8730019200593472	$blah
d,h	d	h	d-h	-54	0.48754993239134437	0.8803199797582254	$blah
c,q	c	q	c-q	-1	0.5840794142042252	0.8806566727578236	$blah
b,m	b	m	b-m	37	0.2131543122670404	0.8808641736864395	$blah
d,z	d	z	d-z	-31		0.8894228892924536	$blah
c,y	c	y	c-y	-39	0.6694588446199107	0.9477570222166518	$blah
b,f	b	f	b-f	-33	0.9265180735593334	0.9573176408596732	$blah
e,y	e	y	e-y	-82	0.3455656244430817	0.962029072823442	$blah
h,j	h	j	h-j	84	0.41085861149653347	0.969588603408625	$blah
a,v	a	v	a-v	38	0.6898676320996214	0.9951493566608947	$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)
);