For Pick Up Max value From Table

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ward Pond SSC Eights! Points: 999 More actions · Answer 1

Hi Tushar..

You could write a loop and scan all of your records to find the MAX() value, but that will certainly be more expensive than using the MAX() function.

Is this an intellectual exercise or is there a reason you're reluctant to use MAX()?

Take care..

Ash DBA SSC Enthusiast Points: 170 More actions · Answer 2

Select Top 1 CustID

from <TableName>

Group by CustID

Sort by Desc

or

Select Max(CustId)

from <TableName>

Ward Pond SSC Eights! Points: 999 More actions · Answer 3

The first alternative would probably be more efficient as an ORDER BY CustID DESC but it's a good call..

Take care..