How will you delete a particular row from a Table?
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / dinesh kumar
delete from table_name where pk_col = value;
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / manoranjan sethy
Delete form TABLE_NAME where value=COLUMN_NAME;
Is This Answer Correct ? | 0 Yes | 0 No |
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 |
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 |
Explain UNION,MINUS,UNION ALL, INTERSECT?
what is auto increment? : Sql dba
What is data types in sql?
When would you denormalize?
8 Answers MBT, Microsoft, MMU,
How well can multiple sessions access the same data simultaneously ?
What is full join in sql?
How to create your own reports in sql developer?
What is sql table?
List different type of expressions with the example.
Does sql between include endpoints?
wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh
What are the most important characteristics of pl/sql?