Thread: how to write an aggregate function which can used like MAX(filedname)
View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 07:14 PM
William Jiang
 
Posts: n/a
Default how to write an aggregate function which can used like MAX(filedname)
Recently, I will write a database application to get the median value
according to the grouped condition.

maybe, just like the following.

SELECT Max(a1) MaxValue, Median(a1) MedianValue FROM test_table

Any suggestion?


Reply With Quote