Sign Up Login


  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

Do you know about aggregate functions? What is row num function? Can it be used all databases?

Question Posted / nilam

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to store only time; not date and time?

723

What is blob datatype?

752

Is oracle a language?

686

What is pragma autonomous transaction in oracle?

741

What is the difference between formal parameters and actual parameters?

723

How to export data to a csv file?

827

Is oracle the best database?

693

What is integrity and what is constraint??Explain with example

1944

How to use group functions in the select clause using oracle?

794

What is logical backup in oracle?

758

What is an oracle table?

735

How to define a cusotmer as a supplier in ORACLE R12

1918

What is a trigger and what are its types?

787

What is flashback in Oracle?

735

How to open a cursor variable?

773