06-06-2003 00:43									#1
	SQL quickie Tired of ads?

how do i find the minimum value of a column based on another column?

ie If I had columns 'age' and 'height', how would I get the min (height) for (say) ages 9,12,15 ommiting all the other ages?

cheers

	06-06-2003 00:46									#2
	Support Apolyton, buy Civilization: The Boardgame

SELECT MIN(height) FROM table WHERE age=9 OR age=12 OR age=15

it might need to be...

SELECT MIN(height) AS MinHeight FROM table WHERE age=9 OR age=12 OR age=15

	06-06-2003 01:25									#3
	Support Apolyton, buy Civilization: The Boardgame

many thanks Asher

	06-06-2003 01:27									#4
	Avatar Enlargement: We've got the solution

No problem. I'm dealing with programming SQL on a daily basis now so it was pretty easy to answer.

	06-06-2003 03:28									#5
	Support Apolyton, buy Civilization: The Boardgame

you got that job you said you had the second interview for a while back?

	06-06-2003 04:28									#6
	Lose 30 kilos (of popups)

Yeah.

Sole programmer for a small business, making an app that calculates and spits out building instructions (they make stairs), maintains a DB of the customers, workorders, and stair models, integrates with Simply Accounting (invoices, etc) and AutoCAD (designs and models).

It's great fun. Great pay, too. And zero supervision.

	06-06-2003 05:53									#7
	Put an end to popups!

Congrats, Asher!

	06-06-2003 06:09									#8
	Lose 30 kilos (of popups)

quote: Originally posted by Asher It's great fun. Great pay, too. And zero supervision.

The 3 'musts' IMHO!

Nice One!

	06-06-2003 07:05									#9
	Support Apolyton, buy GURPS/ Alpha Centauri

SELECT MIN(height) FROM table WHERE age in (9,12,15)

gives the same result and in most circumstances runs quicker (only matters if it is running slowly, of course).

	06-06-2003 09:33									#10
	Suffering from ads?

quote: Originally posted by Asher Sole programmer for a small business, making an app that calculates and spits out building instructions (they make stairs), maintains a DB of the customers, workorders, and stair models, integrates with Simply Accounting (invoices, etc) and AutoCAD (designs and models).

Integrating with AutoCAD? With SQL?

	06-06-2003 09:38									#11
	Get a bigger avatar today!

No, the program just needs to integrate with AutoCAD so he can import blueprints into the program. SQL would only save the filenames of the blueprints.

Simply Accounting is wonderful to work with -- it actually stores all its information in an Access 2000 DB. All I needed to do was toss together a MS Jet OLE DB consumer (via the wizards, took seconds), and I'm putzing around inside all the data that I need with an SQL connection.

Last edited by Asher on 06-06-2003 at 09:44