SAP HANA XSA and HANA Native Development use SQL Script language as one of the principle programming language to drive rationale profound into HANA DB and get greatest execution out of framework. As a feature of SQL Script part, we learn 2 of the most involved Window capacities in HANA called Rank and Dense Rank, as depicted in the video.
RANK: This gives you the positioning inside your arranged parcel. Ties are relegated a similar position, with the following ranking(s) skipped. Accordingly, in the event that you have 3 things at rank 2, the following position recorded will be positioned 5.
DENSE_RANK: This gives you the positioning inside your arranged parcel, however the positions are successive in it. Likewise, no positions are skipped assuming there are positions with different things.
For a given issue we can track down various arrangements and elective strategies. for example Issue is one however we have various ways to deal with resolve the issue. On the off chance that we have comparative sort of an arrangements in our grasp for a given issue, we want to pick the best and precise decision.
Call us on +91-84484 54549
Mail us on - contact@anubhavtrainings.com
Website: https://www.anubhavtrainings.com/
https://youtu.be/p4Z3O-5kuvs
Comments
Post a Comment