Jump to content

sql


Guest asherww11
 Share

Recommended Posts

Guest asherww11

help!!! everyone who knows the northwind database of access i have to select the category names and the most expensive products from each category(there are 8 kinds of categories)i have tried this:(but nothing)SELECT categories.CATEGORYNAME, productname,MAX (products.unitprice), DISTINCT( products.unitprice)FROM products, categoriesWHERE products.productid = categories.categoryidGROUP BY productname

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...