Alasql

by bilbobaggins

HTML

<script src="https://cdnjs.cloudflare.com/ajax/libs/alasql/0.4.2/alasql.min.js"></script>

JavaScript

var data = [{ dep: 'A', qt: 10, price: 5},
 { dep: 'B', qt: 5,  price: 2.30 },
 { dep: 'C', qt: 3,  price: 2.20 },
 { dep: 'D', qt: 1,  price: 4 },
 { dep: 'E', qt: 4,  price: 10 }];
  var red=alasql('SELECT * FROM ? ORDER BY dep LIMIT 2 OFFSET  1 ',[data]);
  console.log(red);