xxxcr

Hi, I need to find the mode of price for multiple different locations. The way I have the query now returns the mode over the entire data set- but not location by location: SELECT top 1 COUNT (*)frequency, price mode, locatFROM TicketsWHERE locat in ('017','018','030')group by locat, priceorder by COUNT (*) desc result:frequency mode locat361 26.00 017 Help on the fixing this would be greatly appreciated!!