JSFiddle - React, Tailwind, and code Playground

by Andrey Gershun

HTML

<script src="http://alasql.org/console/alasql.min.js"></script>
<span id="res"></span>

JavaScript

var DATA_TABLE = [{"rownum": 0, "Surname": "Doe", "Firstname": "John", "Dob": "1 Jan 1980"},
{"rownum": 1, "Surname": "America", "Firstname": "Captain", "Dob": "1 Mar 1940"},];

var res = alasql('SELECT *, Date(Dob) AS d FROM ? ORDER BY d, Surname, Firstname',[DATA_TABLE]);
 


document.getElementById("res").textContent = JSON.stringify(res);