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 |
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.
Explain oracle instance.
Is oracle a programming language?
sql query to get zero records from a table
How are extents allocated to a segment?
Explain the use of inctype option in exp command.
what is port in oracle? how is it related to database application.
What is ADDM Advisor in Oracle?
Select the Nth lowest value from a table?
What is raw datatype?
How to connect ms access to oracle servers?
How to establish administrator authentication to the server?