Hello All,

i have table with two field,

JobDetailID (int) AutoIncreament JobTitle varchar(200)

i need to find the last number of jobdetailID. how can i achieve in self servicing?

Do you mean you want to find the MAX value currently existing in the table ? This can be accomplished using a aggregate scalar query

Matt

MTrinder wrote:

Do you mean you want to find the MAX value currently existing in the table ? This can be accomplished using a aggregate scalar query

Matt

Thanks MTrinder

I have solved like this

 string StrJob = ClaJobClass.GetScalar(JobdetailsFieldIndex.JobDetailId, AggregateFunction.Max).ToString();