sortable

26 rows where pk1 = "e" sorted by sortable_with_nulls descending

✎ View and edit SQL

This data as json, testall, testnone, testresponse, CSV (advanced)

Suggested facets: sortable, text

Link pk1 pk2 content sortable sortable_with_nulls ▲ sortable_with_nulls_2 text
e,n e n e-n 16 0.8696016832340685 0.23880554416624933 $null
e,z e z e-z 16 0.8453039251425987 0.8533354586601858 $blah
e,o e o e-o -19 0.7447051515651959 0.6636888294845347 $null
e,s e s e-s -19 0.6267991790079878   $null
e,x e x e-x 18 0.459570499176731 0.009397431454871041 $null
e,v e v e-v -5 0.43068678785540004   $null
e,l e l e-l 97 0.41494242355134514 0.00256525935857721 $blah
e,w e w e-w -80 0.3825442986168739   $null
e,y e y e-y -82 0.3455656244430817 0.962029072823442 $blah
e,d e d e-d -59 0.3298036635789654 0.4004522548136564 $null
e,j e j e-j 83 0.291861560261786   $blah
e,r e r e-r 20 0.2650227795434089 0.692704598586882 $blah
e,k e k e-k 41 0.19061037094792832   $blah
e,p e p e-p 26 0.1262462698093887 0.33199470393136377 $null
e,a e a e-a 54 0.0913268866309852   $blah
e,b e b e-b 47 0.040231673144616176 0.518963840987604 $null
e,c e c e-c 49   0.4700103949603517 $null
e,e e e e-e 16   0.40417505700074563 $null
e,f e f e-f 68   0.18758254139452712 $blah
e,g e g e-g 94   0.43811609507237825 $blah
e,h e h e-h -69     $blah
e,i e i e-i -77     $blah
e,m e m e-m 50   0.44654739304319446 $blah
e,q e q e-q 34     $null
e,t e t e-t 61     $null
e,u e u e-u 13   0.04599096867721275 $blah

Advanced export

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

CSV options: 

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