0

I need to find the cheapest Honda Civic sold in this table

Sell(DName, Make, ModelNum, Price)

There are other tables, but I am assuming that no other manufacturers have named their make Civic.

So I'm looking to find the lowest price that is of Make Civic. But how exactly do I find the lowest price? I would know if there was a set price (SELECT the make WHEN price < "x amount"), but how about to I go do find the lowest price in the table.

Martijn Pieters
  • 889,049
  • 245
  • 3,507
  • 2,997
Iuli
  • 111
  • 1
  • 3
  • 12

1 Answers1

0

Select min(price) from Sell where DName='Civic'

MichaelT
  • 6,613
  • 6
  • 31
  • 46