mysql - SQL - Selecting data that is the same in multiple rows for a particular key -
i have dataset below:
key user step --------------------- 123 geoff 1 123 geoff 2 123 john 3 456 jane 1 456 jane 2 456 jane 3 456 jane 4
what need select key user same in steps (there can between 1 5 steps in dataset). in example above need query return key 456. appreciated!
instead of comparing min(user)
, max(user)
, can well:
select tablename.key tablename group tablename.key having count(distinct d.user) = 1;
count(distinct d.user)
should more descriptive use case.
Comments
Post a Comment