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.
Click to expand...

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
?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting ASP.NET sessions in a web farm 1
Parameter Type/Size Property Values for VARCHAR(MAX) Stored Proc Parameter 2
determining max pool size 4
Get field length from Database 4
Access Dcount (multiple criteria) 3
Selection query with MAX(textfield) and WHERE textfield LIKE 'mask 5
selecting the right 'MAX' record 3
Select the MAX value 1

Back
Top