In my table having 100 Rec. How can I delete the 7th row??
(we don't know what is data inside the table)

Answer Posted / raghu

delete count(*) = 7 from tbname

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the max length of sqlca?

764


What type of database is db2?

523


Is db2 free?

684


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

710


How to fetch the last row from the table in SQL (db2)?

1037






What is the use of predicate?

586


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2046


Is ibm db2 open source?

586


What is a bind in db2?

592


What is cloudant database?

641


How to find schema of a table in db2?

570


Is ibm db2 free?

574


How to compare data between two tables in db2?

658


How do I import data from excel to db2?

615


Explain the function of data manager.

632