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

Answer Posted / kriahna chaitanya

delete From <table>;

Is This Answer Correct ?    22 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is record in oracle pl sql?

694


What is the difference between the conventional and direct path loader? : aql loader

862


How do you drop a trigger?

705


Can we use distinct and group by together?

781


What is sql and its types?

813






What is a pragma statement?

953


How do you delete duplicates in sql query using rowid?

715


How do you explain an index?

983


Why stored procedure is faster than query?

677


Do ddl statements need commit?

724


What is the starting oracle error number? What is meant by forward declaration in functions?

736


What are system versioned tables?

729


What is record in pl sql?

763


when is the use of update_statistics command? : Sql dba

680


When should I use nosql database?

723