adspace


How do you delete data from a table?

Answer Posted / Hari Krishna Verma

In SQL and PL/SQL, you can use the DELETE statement to remove data from a table. Here's an example: DELETE FROM your_table WHERE condition; Replace 'your_table' with the name of your table and the 'condition' with the criteria for the rows you want to delete.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is bcp? When does it used? : Sql dba

1065


Do we need to rebuild index after truncate?

1151


What is the current version of sql?

1106


define sql insert statement ? : Sql dba

1108


what are all the common sql function? : Sql dba

1141


What is the best sql course?

1062


What is your daily office routine?

2351


If a cursor is open, how can we find in a pl/sql block?

1252


Does group by remove duplicates?

1120


Is primary key clustered index?

1026


Can we use distinct and group by together?

1146


Is primary key always clustered index?

1101


how to use regular expression in pattern match conditions? : Sql dba

1125


what are aggregate and scalar functions? : Sql dba

1142


Can we rollback truncate?

1083