How will you delete a particular row from a Table?
Answer Posted / mohan
delete from emp where empno=&n;
Note:
1. Here &n means the empno which we have to delete from the table.
2. In general we will use primary key column in where clause.
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
How do I order by ascending in sql?
What is difference between mysql and postgresql?
What is a mutating table and a constraining table?
What does varchar include?
How is a PL/SQL code compiled?
What is raid? How does it help storage of databases?
explain normalization concept? : Sql dba
How we can update the view?
Is record in pl sql?
how can you create an empty table from an existing table? : Sql dba
Enlist some predefined exceptions?
What are different types of keys?
What schema means?
how do you know the version of your mysql server? : Sql dba
how to rename an existing table in mysql? : Sql dba