Attributes of Select statement in SQLite

Question

What attributes can I use with Select statement in SQLite 3

Pravin More · Answer

Hi Stephen 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 Raja · Answer

Hi Check out this SqLite Documentation. Hope this will be useful one. http://www.sqlite.org/lang_select.html