[SOLVED] sql query help

[jake2891]

Hi Guys,

 

just a small table example of what im trying to do

sale_id  buyer_id

1          2

1          2

1          4

2          3

3          5

 

Im trying to get all the data out of the table where the sale_id has more than 1 buyer_id so basically im trying to just get the first 2 records back

 

i though it would be something like the following

 

select * from sale where (select count(buyer_id) > 1) // so where the sale_id has more than 1 buyer_id on it

 

but this does not work any help please

 

[Maq]

SELECT sale_id, buyer_id, COUNT(buyer_id) AS count FROM table GROUP BY sale_id HAVING count > 1;

[jake2891]

SELECT sale_id, buyer_id, COUNT(buyer_id) AS count FROM table GROUP BY sale_id HAVING count > 1;

 

 

thanks for that

[Maq]

Sure, if I understood your question correctly it should work.

 

I'm a little confused about this:

 

Im trying to get all the data out of the table where the sale_id has more than 1 buyer_id so basically im trying to just get the first 2 records back

 

Only sale_id 1 has more than 1 buyer, so why would you expect 2 records back?