Thursday, October 20, 2011

Re: [android-developers] Sqlite question

Well,

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