sortable

201 rows sorted by pk2 descending

- column - pk1 pk2 content sortable sortable_with_nulls sortable_with_nulls_2 text

= != contains ends with starts with > ≥ < ≤ like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by pk1 Sort by pk2 Sort by content Sort by sortable Sort by sortable_with_nulls Sort by sortable_with_nulls_2 Sort by text

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: pk1, pk2, text

Link	pk1	pk2 ▲	content	sortable	sortable_with_nulls	sortable_with_nulls_2	text
a,z	a	z	a-z	-38		0.09432579649188222	$blah
b,z	b	z	b-z	-93			$null
c,z	c	z	c-z	-58	0.9637347441012087	0.11453287137889767	$null
d,z	d	z	d-z	-31		0.8894228892924536	$blah
e,z	e	z	e-z	16	0.8453039251425987	0.8533354586601858	$blah
f,z	f	z	f-z	10	0.4515549159652815	0.3987301842569533	$null
g,z	g	z	g-z	15	0.10350187727039162	0.08432913202456382	$null
a,y	a	y	a-y	-82	0.5141561198085891	0.132311848725025	$blah
b,y	b	y	b-y	-29	0.8643529420302863	0.5094056755280374	$blah
c,y	c	y	c-y	-39	0.6694588446199107	0.9477570222166518	$blah
d,y	d	y	d-y	52	0.7489577220696233	0.4391534486737374	$blah
e,y	e	y	e-y	-82	0.3455656244430817	0.962029072823442	$blah
f,y	f	y	f-y	29	0.09917846167904198	0.6547129575231422	$null
g,y	g	y	g-y	15			$null
a,x	a	x	a-x	50	0.07099308600903254		$blah
b,x	b	x	b-x	17		0.22292354720580898	$blah
c,x	c	x	c-x	99			$null
d,x	d	x	d-x	-71	0.5445623787105787		$blah
e,x	e	x	e-x	18	0.459570499176731	0.009397431454871041	$null
f,x	f	x	f-x	59	0.6330767243010155	0.3809043988185208	$blah
g,x	g	x	g-x	65	0.8552933714560903	0.3844824765824649	$null
a,w	a	w	a-w	12		0.33808556214745533	$null
b,w	b	w	b-w	-32	0.15919784298073125		$null
c,w	c	w	c-w	-80		0.3499603437201839	$null
d,w	d	w	d-w	75	0.26455462565889964		$blah
e,w	e	w	e-w	-80	0.3825442986168739		$null
f,w	f	w	f-w	82			$blah
g,w	g	w	g-w	-10	0.5073368852897782	0.037607245571092074	$null
a,v	a	v	a-v	38	0.6898676320996214	0.9951493566608947	$blah
b,v	b	v	b-v	-55	0.024786361898188725	0.9244872952415456	$null
c,v	c	v	c-v	16	0.32684580488130854	0.278256615638806	$blah
d,v	d	v	d-v	76		0.2881048895936893	$null
e,v	e	v	e-v	-5	0.43068678785540004		$null
f,v	f	v	f-v	17	0.6433406842054887		$blah
g,v	g	v	g-v	60	0.3161388944905802	0.44220806383628486	$null
a,u	a	u	a-u	-68		0.2650566289400591	$null
b,u	b	u	b-u	-10	0.7801162418714427		$null
c,u	c	u	c-u	-79	0.6427496480093358	0.18172902651343215	$null
d,u	d	u	d-u	-33		0.551992245577759	$blah
e,u	e	u	e-u	13		0.04599096867721275	$blah
f,u	f	u	f-u	99	0.36203897381751204		$blah
g,u	g	u	g-u	-55	0.9512921405795819	0.7544458252469858	$blah
a,t	a	t	a-t	-86			$null
b,t	b	t	b-t	10			$null
c,t	c	t	c-t	19	0.9807219775189232	0.3940202563397047	$null
d,t	d	t	d-t	45	0.6096309122451303	0.7627371043547087	$null
e,t	e	t	e-t	61			$null
f,t	f	t	f-t	-56	0.26536750832497336	0.5260855265978671	$blah
g,t	g	t	g-t	-40		0.760215295546892	$null
a,s	a	s	a-s	53	0.3241560570046731	0.8787218778231842	$null
b,s	b	s	b-s	43	0.07524386007376704	0.9039285715598931	$null
c,s	c	s	c-s	24		0.38885720324612805	$null
d,s	d	s	d-s	98	0.5225725351302178	0.2973531325173874	$blah
e,s	e	s	e-s	-19	0.6267991790079878		$null
f,s	f	s	f-s	69	0.866447888506801	0.7899846642347539	$null
g,s	g	s	g-s	30		0.3493752654723803	$null
h,s	h	s	h-s	-80		0.7272347853249318	$blah
a,r	a	r	a-r	60	0.6389494948660052		$null
b,r	b	r	b-r	-100	0.33355653860508816	0.44183551186085057	$blah
c,r	c	r	c-r	22	0.0058960835839930725	0.8534479505691046	$null
d,r	d	r	d-r	44		0.7644434453261942	$null
e,r	e	r	e-r	20	0.2650227795434089	0.692704598586882	$blah
f,r	f	r	f-r	52			$null
g,r	g	r	g-r	50	0.4004498163160871		$null
h,r	h	r	h-r	-27		0.4691101271554937	$null
a,q	a	q	a-q	-100	0.9538159275210801	0.7619621990520646	$null
b,q	b	q	b-q	29		0.09229846771273342	$null
c,q	c	q	c-q	-1	0.5840794142042252	0.8806566727578236	$blah
d,q	d	q	d-q	-71			$null
e,q	e	q	e-q	34			$null
f,q	f	q	f-q	-83	0.5542077884611291	0.21595135191867476	$null
g,q	g	q	g-q	58	0.4600969018938087		$blah
h,q	h	q	h-q	-93	0.099083124393048		$null
a,p	a	p	a-p	74	0.7508777995916097		$blah
b,p	b	p	b-p	-73	0.7424166839809987		$blah
c,p	c	p	c-p	80	0.21395287710598743		$blah
d,p	d	p	d-p	-97	0.5740642196263323	0.34070593256029236	$blah
e,p	e	p	e-p	26	0.1262462698093887	0.33199470393136377	$null
f,p	f	p	f-p	64			$null
g,p	g	p	g-p	46	0.40442288450523434	0.11517337266379823	$null
h,p	h	p	h-p	-94	0.4148969058190054	0.23577807386343264	$null
a,o	a	o	a-o	-2	0.9961213802400968		$null
b,o	b	o	b-o	70	0.2993787521999779	0.1035865019182115	$null
c,o	c	o	c-o	-31		0.23126147972818678	$null
d,o	d	o	d-o	-30	0.04551570098321833	0.6974173929101944	$null
e,o	e	o	e-o	-19	0.7447051515651959	0.6636888294845347	$null
f,o	f	o	f-o	-85			$null
g,o	g	o	g-o	-82	0.3970711742472973	0.0187415365856457	$blah
h,o	h	o	h-o	15	0.9053062089782412	0.09171356965909339	$blah
a,n	a	n	a-n	-77		0.62744604170309	$null
b,n	b	n	b-n	-60	0.43818457300770985	0.9872330636315043	$null
c,n	c	n	c-n	96		0.2745974469175383	$null
d,n	d	n	d-n	-75	0.8326283633270679	0.014148367256063832	$null
e,n	e	n	e-n	16	0.8696016832340685	0.23880554416624933	$null
f,n	f	n	f-n	-45	0.44338308606070165	0.6856802654812854	$blah
g,n	g	n	g-n	27	0.7470141234297678	0.23011071607665967	$blah
h,n	h	n	h-n	41	0.7114009771190007		$blah
a,m	a	m	a-m	91	0.5845859902235405		$blah
b,m	b	m	b-m	37	0.2131543122670404	0.8808641736864395	$blah
c,m	c	m	c-m	40	0.44591361207670044	0.7517767865005115	$blah

Next page

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)
);