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 buffer pool and list some of them?

711


Explain the contention situations caused by locks?

681


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

668


What is the default page size of buffer pools?

739


Which component is used to execute the sql statements?

724






What is phantom read in db2?

720


What is rebind in db2?

668


Can we delete records from view?

652


Why select is not preferred in embedded sql programs?

816


What is an instance in db2?

647


What is the maximum number of columns in a db2 table?

829


What language is db2 written in?

676


How do you find the maximum value in a column in db2?

735


Explain about mirror activator disk mirroring?

655


What are the 2 sqlcodes that are returned?

731