from secretGeek.net
Editors for |
SQLike
|
jsLinq
|
jSinq
|
jLinq
|
jimmyLinq
|
nimbleText
|
nimbleSet
An editor for
Thomas Frank's
SQLike
(playground)
SQLike editor
[ | ]
[ ]
(dataJson2)
Given this data
(dataJson)
firstName,lastName,instrument,born John,Lennon,guitar,1940 Paul,McCartney,bass,1942 Ringo,Starr,drums,1940 George,Harrison,guitar,1943
firstName,lastName,instrument,born Roger,Waters,bass,1943 Nick,Mason,drums,1944 Richard,Wright,keyboard,1943 Syd,Barrett,guitar,1946 David,Gilmour,guitar,1946
Execute this query
SQLike.q({ Select: ['*'], From: dataJson, Where: function(){return this.born<1941}, OrderBy: ['instrument','|desc|'] })
← Exec it!!
Examples...
Select/Order by
Custom column
Select Distinct
Select Into
Delete From
Insert Into
Update
Group by
Group by, having
Cross Join
Full Join
Right Join
Left Join
Natural Join
Join Using
Join
Join Implicit
Except all
Except
Insersect All
Intersect
Union all
Union
Pick an example →
Result
No results yet. (Hint: Press
'Exec'
button.)