SQL Recipes a FREE cookbook of SQL queries and examples - View Single Post - Using SQL Query, find minimun price of each brand.?

SandeshSegu · #3 (**permalink**) 08-26-2008, 10:55 AM

Quote:

Originally Posted by Charlie

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 ..

SELECT Brand, min(Price)
FROM TableName
Group BY Brand