How can I delete record at a time by some condition?

I'm a senior programmer.
Working at CamSight, Dental imaging solutions industry.