sortable

26 rows where pk1 = "g" sorted by pk2

✎ View and edit SQL

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

Suggested facets: sortable, text

pk2 26 ✖

pk1 1 ✖

Link pk1 pk2 ▼ content sortable sortable_with_nulls sortable_with_nulls_2 text
g,a g a g-a -20 0.426764006260958 0.9535925176191249 $null
g,b g b g-b -77     $null
g,c g c g-c 50 0.5616833815697281 0.35359807963376766 $blah
g,d g d g-d 84 0.051446079972376046   $null
g,e g e g-e 68 0.4821893962043886 0.8453734186013451 $null
g,f g f g-f 9 0.9745466021257082   $blah
g,g g g g-g -93 0.1804160719608544   $null
g,h g h g-h 44 0.06958542124833644 0.03065709838090591 $null
g,i g i g-i -4 0.41983249376450316 0.3243828920784265 $null
g,j g j g-j -87   0.27210284354621894 $blah
g,k g k g-k 24   0.7549431436683707 $null
g,l g l g-l -28 0.5931342503922638 0.6671325587363496 $null
g,m g m g-m -99     $null
g,n g n g-n 27 0.7470141234297678 0.23011071607665967 $blah
g,o g o g-o -82 0.3970711742472973 0.0187415365856457 $blah
g,p g p g-p 46 0.40442288450523434 0.11517337266379823 $null
g,q g q g-q 58 0.4600969018938087   $blah
g,r g r g-r 50 0.4004498163160871   $null
g,s g s g-s 30   0.3493752654723803 $null
g,t g t g-t -40   0.760215295546892 $null
g,u g u g-u -55 0.9512921405795819 0.7544458252469858 $blah
g,v g v g-v 60 0.3161388944905802 0.44220806383628486 $null
g,w g w g-w -10 0.5073368852897782 0.037607245571092074 $null
g,x g x g-x 65 0.8552933714560903 0.3844824765824649 $null
g,y g y g-y 15     $null
g,z g z g-z 15 0.10350187727039162 0.08432913202456382 $null

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