sortable
107 rows where text = "$null" sorted by sortable_with_nulls
This data as json, CSV (advanced)
Link | pk1 | pk2 | content | sortable | sortable_with_nulls ▼ | sortable_with_nulls_2 | text |
---|---|---|---|---|---|---|---|
f,s | f | s | f-s | 69 | 0.866447888506801 | 0.7899846642347539 | $null |
e,n | e | n | e-n | 16 | 0.8696016832340685 | 0.23880554416624933 | $null |
a,q | a | q | a-q | -100 | 0.9538159275210801 | 0.7619621990520646 | $null |
c,z | c | z | c-z | -58 | 0.9637347441012087 | 0.11453287137889767 | $null |
c,t | c | t | c-t | 19 | 0.9807219775189232 | 0.3940202563397047 | $null |
a,o | a | o | a-o | -2 | 0.9961213802400968 | $null | |
h,h | h | h | h-h | -43 | 0.9999766211030285 | 0.10114076366789415 | $null |
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) );