> On 31 Jan 2024, at 14:32, MichaelDBA <MichaelDBA@xxxxxxxxxxx> wrote: > > Cheat a bit.... > Use a CTE with a limit on the select and then delete everything from the CTE. Whoa! Thank you for that idea. That's thinking with portals. -- Alex Balashov Principal Consultant Evariste Systems LLC Web: https://evaristesys.com Tel: +1-706-510-6800