how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE
Answers were Sorted based on User's Feedback
Answer / prashant shettar
delete from (select rownumber() over() as rowid from tab1)
where rowid =3
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / avi
When you are saying row no 3 , means your data is in sorted format and table having the primary key , so find the row no 3 primary key information and then delete it using the where clause with primary value .
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / santhu
i think each row we can identify using ROWID . using ROWID
we can delete the row like fallowing
delete from <table_name> where rowid=3
correct me if i am wrong........
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / dalwinder singh
delete from (SELECT * FROM (SELECT col1,rownumber() over()
as rn from table where col =value) as tr where rn = 3)
Is This Answer Correct ? | 3 Yes | 5 No |
Answer / ankit
hi
try with key word 'rownum' and 'rowcount'
ex: delete from table where rowcount=3;
correct me if i am wrong
Is This Answer Correct ? | 3 Yes | 11 No |
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
Which is faster delete or truncate?
What is a Resource Control Table(RCT)? Describe its characteristics.
db2 restart logic ?
What is dclgen in db2?
What is view db2?
What is the purpose of rollback and commit?
Where besides the DB2 catalog is database object information stored by DB2?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
What is the picture clause of null indicator variable?
What is reorg in database?