Search results

I need to make a query that will return all records that have the same field (ex. street address) how can i do this? for instance 1|123 street 2|123 street 3|444 block 4|444 block 5|839 town the query should return: 1|123 street 2|123 street 3|444 block 4|444 block

SELECT TOP 1, city FROM (SELECT City, Avg(Salary) AS AvgOfSalary FROM Customer GROUP BY City ORDER BY AVG(Salary) DESC); that seems to be working. anyone see any problems with it?

Thanks Bob! But, I'm doing this as a homework assignment and im pretty sure our professor wants it done in one query. do you have any information on how to join those two together?

Select city From Customer Where MIN(SELECT Avg(salary) FROM Customer GROUP BY city); im thinking it is something like that but i get the error: "At most one record can be return by this subquery."

Let's say I have a table with the following data: Customer: ---------- name | city | salary john| Boston | 14000 billy | Boston | 32000 sam | Boston | 12000 jj | Dallas | 6000 greg | Dallas | 8000 josh | LA | 1200 ally | LA | 600000 bill | LA | 12000 bob | LA | 9800 how can i list the city...