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


Please Help Members By Posting Answers For Below Questions

Which query operators in sql is used for pattern matching?

520


What is field delimiter?

607


What is the use of desc in sql?

473


Explain the the delete statements in sql?

563


what's the difference between a primary key and a unique key? : Sql dba

484






What schema means?

500


What is view? Can we update view

846


Does sql view stored data?

510


Show the two pl/sql cursor exceptions.

581


What is dml with example?

490


Which tcp/ip port does sql server run?

510


write an sql query to find names of employee start with 'a'? : Sql dba

552


What are %type and %rowtype for?

588


What is cte?

551


what is the functionality of the function htmlentities? : Sql dba

490