IBM Infosphere Datastage, Netezza, Microstrategy, SSIS, SSRS,Hadoop, BI, ETL, Data warehouse, SQL Server, Tableau, mongoDB
rowid is a hidden column in all netezza tables
This comment has been removed by a blog administrator.
My favorite query for finding/deleting duplicates is using rowid:select *--delete from table_with_duplicate t_remove_thiswhere exists (select 1 from table_with_duplicate t_keep_this where t_remove_this.keyfield1 = t_keep_this.keyfield1 and t_remove_this.keyfield2 = t_keep_this.keyfield2 and t_remove_this.keyfield3 = t_keep_this.keyfield3 and t_remove_this.keyfield1.rowid > t_keep_this.rowid)
last line must be and t_remove_this.rowid > t_keep_this.rowid)
NETEZZA Online Training, ONLINE TRAINING – IT SUPPORT – CORPORATE TRAINING http://www.21cssindia.com/courses/netezza-developer-online-training-21.html The 21st Century Software Solutions of India offers one of the Largest conglomerations of Software Training, If you’re serious about a career in IT, 21st Century would like to provide you a guidance don’t hesitate to organize a free demo session. For any further information regarding the courses once go through our website Visit: http://www.21cssindia.com | Call Us +917386622889 - +919000444287 - firstname.lastname@example.org
I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in NETEZZA TRAINING, kindly contact us http://www.maxmunus.com/contactMaxMunus Offer World Class Virtual Instructor led training on TECHNOLOGY. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.For Demo Contact us.Sangita MohantyMaxMunus E-mail: email@example.comSkype id: training_maxmunusPh:(0) 9738075708 / 080 - 41103383http://www.maxmunus.com/