This blog is home to share my experiences, views, learning and findings on open source business intelligence tools like Jasper report. This block cover information of Jasper iReport as well jasper server detail.
Wednesday, March 13, 2024
Remove duplicate row with rank() analytical function.
SELECT
DECODE(ROW_NUM,ROW_RANK,SAL,NULL) AS AVOID_DUPLICATE
No comments:
Post a Comment