How will you delete a particular row from a Table?
- 7 Answers
- 14598 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
Can we have two clustered index on a table?
What is the difference between Union and Union all. Which is faster.
Write a sql select query that only returns each name only once from a table?
Enlist the data types that can be used in pl/sql?
Mention what are different methods to trace the pl/sql code?
what is online transaction processing (oltp)? : Sql dba
what is unique key constraint? : Sql dba
is mysql query is case sensitive? : Sql dba
what is denormalization. : Sql dba
Which sql most popular?
What are different functions in sql?
What are sql data types?
Is it possible to link two groups inside a cross products after the cross products group has been created?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What is oracle pl sql developer?
