Home / server / Questions / 194490
Accepted
rumz
Asked: 2010-10-26 04:53:54 +0800 CST

Informix top command?

  • 772

Is there a top operator for informix like there is in SQL Server?

I want to run a delete that will just delete the top say 1000 records based on a ordered select.

e.g. 

delete from table 
 where id in (select top 1000 id from table order by date desc)
sql-server informix

1 Answers

  1. Best Answer
    • 2