[SOLVED] Returning number of occurence of distinct values

[jellis]

Hi all,

 

I've tried searching but have achieved nothing so far.

 

I have a table as follows: -

del_id

booking

fname

lname

email

 

What I'd like to do is return DISTINCT bookings, but also COUNT how many time bookings are repeated.

 

So the output would return the booking number and how many people on that booking.

 

Thanks ladies and gents.

 

 

[bubblegum.anarchy]

SELECT booking, count(*) 
FROM bookings 
GROUP BY booking

[jellis]

Wow... that was so much easier than I anticipated.

 

Here I was trying subqueries etc... and the answer was there all along.

 

Thanks a bunch!