what is the use of rank function?
Answer / soujanya
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.
eg: SELECT RANK(15500, .05) WITHIN GROUP
(ORDER BY salary, commission_pct) "Rank"
FROM employees;
Is This Answer Correct ? | 2 Yes | 0 No |
How to find out what privileges a user currently has in oracle?
How to view existing locks on the database?
Can we convert a date to char in oracle and if so, what would be the syntax?
How to define a variable to match a table column data type?
How to call a stored procedure inside a trigger? Give an example.
what is insert all statement in sql
what are pseudocolumns?
Explain the use of record length option in exp command.
what is RAID technology?which is better RAID 0+1 OR RAID 5?
What is proxy method?
Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)
What is meant by recursive hints ?