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
What is varchar example?
what is the stuff function and how does it differ from the replace function? : Sql dba
How do I make my sql query run faster?
How do I remove sql developer from windows 10?
Why is sql better than hql?
What are basic techniques of indexing?
What is sql in oracle?
Why do we need pl sql?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What are its different types of dbms?
What does cursor do in sql?
what does the t-sql command ident_current does? : Transact sql
What is the use of sqlerrd 3?
How do I remove sql plus from windows 10?
Why do we create stored procedures & functions in pl/sql and how are they different?