|
Steve, You need: count(*) > 1000 This should return the set you want. Test it first with Select * from my_table where count(*) >
1000 There is also count = last which will give
you the last row in the table. Troy From: It seems that I used to sometimes do something like this : DELETE ROWS FROM MY_TABLE WHERE COUNT() > 10000 This was usually an ad hoc fix to a mistake of my doing, like (manually)
INSERTing||LOADing||GATEWAYing a bunch of rows that were already in the
table. In my example, the assumption is that the 10001-th row starts the
set of DUPLICATES. So, I'd like to dump all rows above a certain
row-count, if you will. There is no other restriction, i.e. no
WHERE-clause, so this should work, in principle. In practice, I can't recall exactly what I once did nor can I find
anything relevant in the HTML help, etc. Any ideas? Thanks, Steve in |
