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



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

Post New Answer

More Oracle General Interview Questions

How to loop through data rows in the implicit cursor?

0 Answers  


Can multiple columns be used in group by in oracle?

0 Answers  


How many file formats are supported to export data?

0 Answers  


How would you extract DDL of a table without using a GUI tool?

1 Answers  


How to create a stored function in oracle?

0 Answers  


What is the data pump import utility?

0 Answers  


What is difference between truncate and delete?

0 Answers  


What privilege is needed for a user to insert rows to tables in another schema?

0 Answers  


Explain oracle left join with an example?

0 Answers  


How to call a stored procedure inside a trigger? Give an example.

1 Answers   Exilant,


Name the three major set of files on disk that compose a database in Oracle?

0 Answers  


How to loop through a cursor variable?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)