android sqlite query with same ID

Question

below is my sqlite table. I want to select those column with same ID numbers.

id object

"0" "person"

"1" "person"

"2" "person"

"3" "person"

"4" "chair"

"5" "chair"

"5" "person"

"6" "chair"

"6" "person"

"7" "person"

"8" "chair"

"8" "person"

"9" "chair"

For example, below same row Id has to be queried from the above table.

"5"
"6"
"8"

please help me to prepare a sqlite android query to select those same "id".

thanks in adv Senthil

pls see this question stackoverflow.com/questions/28712482/… — shuabing
– shuabing, Commented Jul 1, 2016 at 9:00

CL. · Accepted Answer · 2016-07-01 09:08:01Z

1

Use grouping, and count how many rows are in the group:

SELECT id
FROM MyTable
GROUP BY id
HAVING COUNT(*) > 1;

edited Jul 1, 2016 at 9:08

answered Jul 1, 2016 at 8:55

CL.

182k18 gold badges241 silver badges282 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tharkius · Accepted Answer · 2016-07-01 08:45:52Z

0

This is one way to do it, maybe not the more performative one, though.

SELECT o1.*, (SELECT COUNT(*) FROM objects o2 WHERE o2.id = o1.id LIMIT 1) as count
FROM objects o1
WHERE count > 1;

answered Jul 1, 2016 at 8:45

Tharkius

3,6142 gold badges23 silver badges34 bronze badges

Collectives™ on Stack Overflow

android sqlite query with same ID

id object

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

id object

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related