how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c
Answer Posted / pratap
delete from table name;
or truncate table name;
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
What are aggregate and scalar functions?
How are sql commands classified?
What is native sql query?
What is plpgsql language?
What is the largest value that can be stored in a byte data field?
What is the best partition size for windows 10?
What is the purpose of normalization?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What is sql integrity?
Are null values same as that of zero or a blank space?
What is sql analyzer?
Can %notfound return null after a fetch?
explain mysql aggregate functions. : Sql dba
How do you concatenate in sql?
Enlist the characteristics of pl/sql?