Can some one please tell me the exact difference between the following statements ,
INSERT INTO table1 VALUES ((select count(column-name) from table-name2)+1);
here i am using the count function to auto-increment the value..
The same functionality can be done with
what will happen when both of this queries are executed and also please tell me the drawbacks of using the count over sequence