example: 24 hours back SELECT is hit the particular table,but didn't give the result keep on executing ...so my delete query also waiting for SELECT complition..i want to avoid this...

Thanks man ,i got it .i dont want simultaneous process.whenever delete query try to hit the table (waiting for SELECT complition)i want to quit the SELECT and run DELETE based...