Hi, I need to construct a SQL query to find the minimun price of each brand in a table:
Table Example:
Code:
Brand Price
BMW $10,000
BWM $ 20,000
HONDA $12,000
HONDA $22,000
TOYOTA $30,000
TOYOTA $44,000
Output of the Query Should be:
Code:
Brand Price
BMW $10,000
HONDA $12,000
TOYOTA $30,000
This might be easy, but i don't know, plz help. I need the SQL statement:
Select *
From table
Where ..