Results 1 to 4 of 4
Feb 17, 2005, 10:07 #1
- Join Date
- Aug 2002
- 0 Post(s)
- 0 Thread(s)
Is it possible to use an aggregate function ACROSS columns?
I have a dataset that has 6 columns of values, and I want the maximum for each row ACROSS the columns. It seems that MAX(), SUM() etc work within the columns, but not across them.
Does anyone know of a way to MAX across columns, or a cunning SQL statement that would do the job using a temptable?
BTW, I cannot modify the database structure, so normalising the dataset is out the window.Juddster