How will you delete a particular row from a Table?
Answer Posted / priya
delete from table where primarykey/uniquekey_columnname
= 'something';
I hope it will delete a desired particular row.
But if you want to delete a 100th row or something like
that answer will be different
Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Can a table contain multiple primary key’s?
what are the differences between char and varchar? : Sql dba
What is the difference between the conventional and direct path loader? : aql loader
Does view contain data?
Explain the purpose of %type and %rowtype data types with the example?
What is the usage of sql functions?
How to know the last executed procedure?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
Which function is used to return remainder in a division operator in sql?
what are the 'mysql' command line arguments? : Sql dba
Is ms sql traffic encrypted?
What are the advantages of pl sql?
What is pl sql code?
How do I edit a stored procedure?
what is the difference between join and union? : Sql dba