I am trying to insert into EMPLOYEE table
Insert into employee(ID, NAM, flag)
values ((select max(ID)+1 from employee),'test','Y')
ID is the primary key
but the above insert is failing,
unique constraint violated
any idea why since i am doing 'select max(ID)+1'