Do you know about aggregate functions? What is row num function? Can it be used all databases?
Answer / nilam
SQL aggregate functions return a single value, calculated from values in a column.
Useful aggregate functions:
AVG() - Returns the average value
COUNT() - Returns the number of rows
FIRST() - Returns the first value
LAST() - Returns the last value
MAX() - Returns the largest value
MIN() - Returns the smallest value
SUM() - Returns the sum
Is This Answer Correct ? | 6 Yes | 0 No |
What are the different editions of oracle?
What is a nested table?
Please explain oracle data types with examples?
Is java required for oracle client?
How to assign values to data fields in record variables?
What is ADDM Advisor in Oracle?
How are extents allocated to a segment?
find out the third highest salary?
92 Answers CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,
How to use existing values in update statements using oracle?
How to insert a new row into a table in oracle?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How to write a query with a right outer join in oracle?