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

Command prompt result in label. Python 2.7 -

javascript - How do I use URL parameters to change link href on page? -

amazon web services - AWS Route53 Trying To Get Site To Resolve To www -