MySQL query to get values based on same column

Question

I am using Mysql database, Below is one of my table,

enter image description here

I want get Route id from above table based on the busstop id. For example i will pass the bus top id as 9 and 11. So i have to get route id which falls under these two bus stops. same time i shouldn't get route id if any one location is not exists. As in above table i shouldn't get 3 because 11 is not exists in that route 3. output as below

enter image description here Any suggestions are welcome. Regards Sangeetha

Can you please paste your output also, so that we can help you out... For eg. if you entered bustopid as 9 & 11 then what output you exactly want... — Pankaj K
– Pankaj K, Commented May 16, 2015 at 6:19
So the order in which stops occur is unimportant? 11,9 is the same as 9,11? — Strawberry
– Strawberry, Commented May 16, 2015 at 8:48

Strawberry · Accepted Answer · 2015-05-16 08:50:32Z

1

You can use post aggregation filtering to check for both conditions

SELECT routeid FROM t GROUP BY routeid
HAVING SUM(bustopid=9)>0
AND SUM(bustopid=11)>0

edited May 16, 2015 at 8:50

Strawberry

34k14 gold badges43 silver badges57 bronze badges

answered May 16, 2015 at 6:31

Mihai

26.8k8 gold badges71 silver badges87 bronze badges

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

Collectives™ on Stack Overflow

MySQL query to get values based on same column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related