Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Comments

thanks lots Gianni Ceresa

in Remove duplicate Row Comment by User_GCQ4K Nov 30, 2023 5:08PM
Thanks lot Gianni Ceresa

in Remove duplicate Row Comment by User_GCQ4K Nov 30, 2023 5:07PM
Hello User_GCQ4K, Query is running perfect with out adding ROW_NUMBER() OVER(PARTITION BY TRUNC(LB.CHANGEDATE) ORDER BY LB.CHANGEDATE ASC) AS Rownum, when I add above line then it give me error. Thanks for your time

in Remove duplicate Row Comment by User_GCQ4K Nov 29, 2023 8:41PM