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 analyze command used for?
What are set operators?
What is the difference between Sleep and Wait? (Java)
What is an oracle tablespace?
Can group functions be mixed with non-group selection fields?
What is varray?
How to delete multiple rows from a table in oracle?
How to define a specific record type?
Explain how are indexes update?
How to change program global area (pga) in oracle?
How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.
Explain an index segment?