Hi,
I have a table like this:
CREATE TABLE customer_mapping
(
"Name" varchar(128) NOT NULL,
"ID" int8 NOT NULL
)
Data looks something like this:
"john" 1
"peter" 1
"test" 2
"george" 3
What I would like is to write a query where I can specify multiple names and get the IDs which have them.
For now it seems the most efficient way is to use INTERSECT statement:
SELECT "ID" from customer_mapping WHERE "Name"='john'
INTERSECT
SELECT "ID" from customer_mapping WHERE "Name"='peter'
Although, I don't know how exactly to use ORDER, OFFSET and LIMIT in this case...
Anyway, is there any better way of doing this? (I can't change the table structure.)
Thanks, Sebastjan
