We often come across situations where we have to rank things/persons based on certain criteria, such as ranking Students based on their scores.
Take, for example, a SCORES table with two columns: STUDENT_IDVARCHAR2(10), SCORE NUMBER(5). To rank these Students based on their scores, a straightforward approach is to open a cursor, order them by SCORE and then loop through the cursor to Rank them.
However, there is another very short approach for this that takes 1 SQLstatement. Let


Different Types of Data Models Explained with Examples
In the modern world, data is everything and everywhere. With so much access to technology, data has become a valuable resource for any business. Albeit a complex one. Data is