find maximum number

Abhinav_jain_mca · August 25th, 2004, 04:58 AM

i want to find the maximum ID ,so what's the query.

abhinavjain

dhay1999 · August 25th, 2004, 08:31 AM

select max(id) as maxid from table

VIshwastrivedi · September 28th, 2004, 07:31 AM

what kind of ID, plz send me detailed question.

Anantsharma · September 28th, 2004, 07:40 AM

Dhay1999 is correct if u want the maximum id (biggest Id) from a table. ur requierment may be something different then I ask the same question as Vishwastrivedi.

Good luck

B. Anant

vohra_vikas · September 28th, 2004, 08:13 AM

the above answer is going to work but don't think this is ur problem so specify ur problem in detail