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 |
how we will do null data selection in cobol-db2 program
List out the buffer pools in db2
Mention the various locks that are available in db2.
What is the difference between TYPE 1 index & TYPE 2 index
What is the syntax for creating a table in the db2 database?
What is db2 bind process?
What is db2 optimizer?
What do you need to do before you do EXPLAIN?
what is rebinding ?
What is cursor stability?
What is the use of runstats in db2?
what is datacom db?