The easiest query would be SELECT * FROM <Your Table Name> WHERE id = 101;
Your result set would be
101 a
101 b
101 c
Reference SQLLite here http://www.sqlite.org/lang_select.html
On Thu, Oct 20, 2011 at 9:31 PM, NAVI NEW <navi44445@gmail.com> wrote:
Hello Sir,
i have a table in sqlite
id value
101 a
101 b
101 c
102 d
104 e
104 f
103 g
Here i want to retrieve 101 id all data like a,b and c , Please help
me which query is best for this approach.
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
No comments:
Post a Comment