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 |
How to loop through data rows in the implicit cursor?
Can multiple columns be used in group by in oracle?
How many file formats are supported to export data?
How would you extract DDL of a table without using a GUI tool?
How to create a stored function in oracle?
What is the data pump import utility?
What is difference between truncate and delete?
What privilege is needed for a user to insert rows to tables in another schema?
Explain oracle left join with an example?
How to call a stored procedure inside a trigger? Give an example.
Name the three major set of files on disk that compose a database in Oracle?
How to loop through a cursor variable?