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 to select unique records from a table? : Sql dba
What is the importance of sqlcode and sqlerrm?
Is keyword pl sql?
How do I remove sql plus from windows 10?
Is primary key an index?
What are the types of join and explain each?
Cite the differences between execution of triggers and stored procedures?
What do you think about pl/sql?
Are views faster than queries?
Which is the correct statement about truncate and delete?
What are sql queries used for?
What is identity column in sql server?
Name the operator which is used in the query for pattern matching?
what is schema? : Sql dba
What is set transaction?