select maximum in a table

[shalini166]

Hi

i have table empid,empname.. .........etc.In my webform i have empname etc.but not empid.

i empid is inserted based on the maximum of the empid in the table.At first my table was empty.then how should i find maximum of table.


pls help me.

[antonopn]

Try this

select top 1 from mytable order by empid desc

This will give you the bigest empid number!

[deric]

You can also make use of the MAX function...

[Delerna]

You can also make use of the MAX function...

and a benefit for that is you can set a starting value for when the table is empty.
Suppose that a number sequence should start at 1000 an the table is empty then
[code=sql]
SELECT isnull(max(id), 1000) as id
FROM YourTable
[/code]