how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c

Answer Posted / chinna

truncate table <tbl_nm>

Is This Answer Correct ?    14 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between nchar and nvarchar?

538


How to connect a sql*plus session to an oracle server?

619


How do I run a sql query in pgadmin 4?

546


How to read xml file in oracle pl sql?

504


Is pl sql useful?

537






Explain normalization and what are the advantages of it?

516


Is pl sql still used?

507


Why do we create stored procedures & functions in pl/sql and how are they different?

500


Does sql full backup truncate logs?

527


Does mysql_real_escape_string prevent sql injection?

537


What is the size of partition table?

551


Is natural join same as inner join?

505


Which one is better subquery or joins?

553


How to change sql*plus system settings?

540


What is cartesian join in sql?

557