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 |
Explain various types of locks in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is bufferpool in db2?
Is db2 a database?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
what happend with out using Commit,when closing cursor and program?
What action db2 takes when a program aborts in the middle of a transaction?
What are the 2 sqlcodes that are returned?
What is correlation names?
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
What is an asychronous write?