Could it be that the first query is using max which will only return the max
for b.lot and b.price..
so maybe.
select sum(max(b.lot))as quantity, max(b.price) as price from bid b, person
p where b.auction_id = 84 and p.id = b.person_id ;
Just a thought.
-Original Message-
From: [EMAIL
I'm not sure this is the right list for this but maybe someone could point
me in the right direction.
We are getting some DB servers to test performance. I was wondering if
anyone knows where we can get a test script of sorts that would allow us to
check performance on each of the servers.
TIA
You should be able to query the system table that holds that column names.
Not sure which it is tho.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
Of G. Anthony Reina
Sent: Monday, September 11, 2000 4:38 PM
To: [EMAIL PROTECTED]
Subject: [SQL] How can I s
How can a view a function after it's created ?
I've created a SQL function that I need to review and possibly change. What
is the best way to go about this.
TIA
Please ignore.
Thanks
