Rank calculates the rank of a value in a group of values. Rows with equal values for the ranking criteria receive the same rank. Oracle then adds the number of tied rows to the tied rank to calculate the next rank. Therefore, the ranks may not be consecutive numbers. Consider the following Schema CREATE TABLE USER_TEST ( user_id numeric(12), first_name varchar2(32), last_name varchar2(32), age numeric(3), salary numeric(7) ); insert into user_test values(1, 'Pardeep', 'Kumar', 26, 20000); insert into user_test values(2, 'Raj', 'Sharma', 23, 15000); insert into user_test values(3, 'Jai', 'Singh', 30, 30000); insert into user_test values(4, 'Rana', 'Pratap', 32, 35000); insert into user_test values(5, 'Nakul', 'Gupta', 23, 16000); insert into user_test values(6, 'Ritu', 'Kumar', 22, 10000); insert into user_test values(7, 'Sita', 'Dikshit', 27, 22000); insert into user_test val...
Fun Drive with Technology