Using SQL Query, find minimun price of each brand.?

#1 (**permalink**) 06-14-2008, 12:57 PM

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

#2 (**permalink**) 06-16-2008, 11:14 AM

SELECT brand_name , min(price) 

FROM table_name

ORDER BY brand_name

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

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

User Name		Remember Me?
Password

ANSWER(S):