Problem with max query

  • Thread starter Thread starter b.ashish.b
  • Start date Start date
B

b.ashish.b

How can we get the maximum value from multiple fields within the same
record in SQL-Server 2000.
 
How can we get the maximum value from multiple fields within the same
record in SQL-Server 2000.

You may get a better answer in one of the SQL Server newsgroups, but...

Can you not just use:
SELECT MAX(field1), MAX(field2) FROM tablename
?
 
Back
Top