Is there a better way than this?

I'm new to MySQL and I'm looking for some guidance. I have a table A, with two columns X and Y with the following data: | X|Y| 1 24 1 25 2 25 2 26 3 27 I want my SQL query to return "2" following this verbose logic: SE

Re: Is there a better way than this?

IN (24) > > Chris W > > > Tim Molter wrote: >> >> I'm new to MySQL and I'm looking for some guidance. I have a table A, >> with two columns X and Y with the following data: >> >> |   X    |    Y    | >>    1          24 >>    1