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 is the meaning of recursive hints in oracle?
Explain a segment?
Explain the use of online redo log files in oracle.
What is bind variable in oracle 11g?
How to convert characters to times in oracle?
What do you mean by merge in oracle?
What do you mean by merge in oracle and how can we merge two tables?
What is meant by recursive hints in oracle?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
How to transfer database(500 gb) of oracle enterprise edition to standard edition downtime is only 1 hour not using exp/imp option ?
How to assign values to data fields in record variables?
What types of joins are used in writing subqueries?