sortable
11 rows where pk1 = "d" and text = "$null" sorted by sortable
This data as json, testall, testnone, testresponse, CSV (advanced)
Link | pk1 | pk2 | content | sortable ▼ | sortable_with_nulls | sortable_with_nulls_2 | text |
---|---|---|---|---|---|---|---|
d,d | d | d | d-d | -97 | 0.43352340132584843 | $null | |
d,b | d | b | d-b | -81 | 0.772480884951224 | $null | |
d,n | d | n | d-n | -75 | 0.8326283633270679 | 0.014148367256063832 | $null |
d,q | d | q | d-q | -71 | $null | ||
d,o | d | o | d-o | -30 | 0.04551570098321833 | 0.6974173929101944 | $null |
d,l | d | l | d-l | -10 | 0.7028549421857689 | 0.23053804129850775 | $null |
d,i | d | i | d-i | 42 | 0.40642812467051925 | $null | |
d,r | d | r | d-r | 44 | 0.7644434453261942 | $null | |
d,t | d | t | d-t | 45 | 0.6096309122451303 | 0.7627371043547087 | $null |
d,a | d | a | d-a | 48 | 0.3119572443946952 | 0.37530695942531844 | $null |
d,v | d | v | d-v | 76 | 0.2881048895936893 | $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) );