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 |
What is thread join () in threading?
Does oracle use sql?
explain mysql aggregate functions. : Sql dba
how to select first 5 records from a table? : Sql dba
What is embedded sql with example?
25.67,-1 Trunc = 20 Round= 30 HOW????
I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman
What does := mean in pl sql?
What is pl/sql table? Why it is used?
How can I see all tables in sql?
How to call shell script from pl sql procedure?
What is nvarchar in sql?