identity value reset delete

SQL delete statement is used to delete records from table based on specific conditions which are passed in where clause.