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
Which query operators in sql is used for pattern matching?
What is field delimiter?
What is the use of desc in sql?
Explain the the delete statements in sql?
what's the difference between a primary key and a unique key? : Sql dba
What schema means?
What is view? Can we update view
Does sql view stored data?
Show the two pl/sql cursor exceptions.
What is dml with example?
Which tcp/ip port does sql server run?
write an sql query to find names of employee start with 'a'? : Sql dba
What are %type and %rowtype for?
What is cte?
what is the functionality of the function htmlentities? : Sql dba