How to get duplicate value from one column in sqlite?

Question

I have the following record in a table:

id | Name | 

1  | abc 
2  | bac
3  | abc
4  | cab
5  | abc
6  | abc
7  | cab
8  | cab
9  | cab

I would like to retrieve only records with 'abc' entries. How do I construct a query to accomplish this?

Here's an example output illustrating what I mean:

1  | abc 
3  | abc
5  | abc
6  | abc

i know but this table data are coming randomly. @JithinShaji — user3940156
– user3940156, Commented Aug 14, 2014 at 6:38
What ever it is, If you use a SELECT with that WHERE condition, we will get the desired Out put. — Jithin Shaji
– Jithin Shaji, Commented Aug 14, 2014 at 6:44
What do you mean with "randomly"? What is the difference between the output and your desired output? — CL.
– CL., Commented Aug 14, 2014 at 8:34

Rahul · Accepted Answer · 2014-08-14 06:49:26Z

1

SELECT * FROM [TABLE_NAME] WHERE Name = "abc";

answered Aug 14, 2014 at 6:49

Rahul

1611 silver badge11 bronze badges

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

1 Answer 1