Attributes of Select statement in SQLite
What attributes can I use with Select statement in SQLite 3
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pravin MorePosted Oct 31, 2011, 12:50 AM
ALL or DISTINCT keywords may follow the SELECT keyword like below
SELECT ALL ,
SELECT DISTINCT
You can use "case when....then...else..end"
aggregate function like sum().
Thank you,
Pravin.
Prabhu RajaPosted Oct 31, 2011, 12:40 AM
Check out this SqLite Documentation. Hope this will be useful one.
http://www.sqlite.org/lang_select.html