how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c
Answer Posted / hannan oca
delete from tablename; will remove all records but we can
rollback these values.
truncate tablename; will remove all records but we cannot
rollback the table values if we want that values in future.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How do I order columns in sql?
What is pls integer?
Can sql developer connect to db2?
Is sql a dbms?
What is blind sql injection?
Can dml statements be used in pl/sql?
How to convert comma separated string to array in pl/sql?
How do you concatenate in sql?
Is coalesce faster than isnull?
What is view explain with example?
What are different types of queries in sql?
how many sql dml commands are supported by 'mysql'? : Sql dba
What are predefined functions in sql?
How to select random rows from a table?
Differentiate between pl/sql and sql?