Sorting SQLite Table

50 views
Skip to first unread message

echo

unread,
May 18, 2012, 11:24:58 AM5/18/12
to JSDB
Hi, guys!

Could you tell me is there any to sort SQLite Table?
Or how to make Select-query with ORDER BY clause?

Jason S

unread,
May 21, 2012, 7:41:17 AM5/21/12
to js...@googlegroups.com

Those are SQL questions, not JSDB questions... certainly if anyone here has a response you might get an answer -- but I think you'd have better luck on a more general forum like stackoverflow.com

Al Fes

unread,
May 21, 2012, 12:14:35 PM5/21/12
to js...@googlegroups.com
You're wrong, man.
I needed such a consctruction
 
database.select("AGGBALGROUP_STAT", "WHERE 1=1 AND DT=" + database.escape('2012-04-01') + " AND AGG_LEVEL=1 ORDER BY id LIMIT 10")

понедельник, 21 мая 2012 г., 15:41:17 UTC+4 пользователь Jason S написал:
Reply all
Reply to author
Forward
0 new messages