How will you delete a particular row from a Table?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / ss321

7 Answers
13990 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How will you delete a particular row from a Table?..

Answer / suma

delete from rmployees where employee_id=101

Is This Answer Correct ?

20 Yes

3 No

How will you delete a particular row from a Table?..

Answer / rakesh

delete from emp e1
where n = (select count(distinct rowid)
from emp e2
where e2.rowid <= e1.rowid)

Note:Here "n" means Nth row..

Is This Answer Correct ?

9 Yes

2 No

How will you delete a particular row from a Table?..

Answer / 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

How will you delete a particular row from a Table?..

Answer / dinesh kumar

delete from table_name where pk_col = value;

Is This Answer Correct ?

1 Yes

1 No

How will you delete a particular row from a Table?..

Answer / manoranjan sethy

Delete form TABLE_NAME where value=COLUMN_NAME;

Is This Answer Correct ?

0 Yes

0 No

How will you delete a particular row from a Table?..

Answer / chandra shekhar

Sorry guys this is not an answer to the asked question.
-- Just a small test --

<HTML>
<BODY>
<MARQUEE>TESTING THIS WEBSITE</MARQUEE>
<a href="http://www.allinterview.com/">All Interview website</a>
</BODY>
</HTML>

Is This Answer Correct ?

2 Yes

5 No

How will you delete a particular row from a Table?..

Answer / 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