Hi everyone !
I am facing difficulties in displaying my Top 5 values in the query result. In my table called "Customers", I have 2 fields, "Names" and "price" with 10 records.
Select Customers.name, Customer.price
From Customers
( This shows all the 10 records)
I am trying to show only the top 5 highest price in the query result, any idea how I can do that?
Another question is I have another table called "Stores", I have 2 fields. "Store_name" and "ratings" . I am planning to show the top 5 ratings for each Store_name, so the query will be group by Store_name and each Store_name will show the top 5 highest ratings out of the many records. any idea how can I achieve that? Thanks !
Select Stores.store_name, Stores.ratings
From Stores
Group by Stores.store_name
(This shows all the records)