HI LOW AVERGAGE

[Andy]

Hi;

Have a database that needs to show the Highest price for a product and the
lowest price.

$100.00 low price $1,000.00 high.

Any suggestions?

Andy
www.WTCInformMe.com

 

[Van T. Dinh]

... and the structure of the Table that store the prices?

 

[Slaven Bojko]

You can try something like

SELECT TOP 1 price FROM table ORDER BY price

and

SELECT TOP 1 price FROM table ORDER BY price DESC

Of course, you should change table and price to coresponding table and field
from your database.

Regards,

Slaven

 

[Dale Fye]

How about something like:

SELECT ProdID
, MIN(Price) as MinPrice
, MAX(Price) as MaxPrice
FROM yourTable
GROUP BY ProdID

--
HTH

Dale Fye


Hi;

Have a database that needs to show the Highest price for a product and
the
lowest price.

$100.00 low price $1,000.00 high.

Any suggestions?

Andy
www.WTCInformMe.com