Teradata : Delete n rows from a table -


i wanted delete first n rows or last n rows table in teradata. not getting correct query doing this. can please tell me how can this?

i dont have experience in working teradata if working sql make :

delete |tablename| |the id column name| in (select top(n) |the id column name| |tablename|) 

so example if have customer table , table contains customerid primary key column , customername , delete first 10 rows :

delete customer  customerid in (select top(10) customerid  customer) 

i hope can


Comments

Popular posts from this blog

'hasOwnProperty' in javascript -

How to put a lock and transaction on table using spring 4 or above using jdbcTemplate and annotations like @Transactional? -

How to understand 2 main() functions after using uftrace to profile the C++ program? -