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
Define commit, rollback and savepoint?
What is rtm in testing?
Explain lock escalation? : Transact sql
What is trigger in sql?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
What is %type in pl sql?
what is 'mysqldump'? : Sql dba
what are the drivers in mysql? : Sql dba
how to get a list of columns in an existing table? : Sql dba
what's the difference between a primary key and a unique key? : Sql dba
what is innodb? : Sql dba
Which is faster view or stored procedure?
What is the most restrictive isolation level? : Transact sql
How many joins can you have in sql?