WHT ARE THE AGGREATE FUNCTIONS?

Answer Posted / b.chandan kumar patra

this function returns a single row,based on group of rows.
this function an apperars in select list and having clause
only,
the aggregate functions are
sum(),avg(),min(),max(),count()etc.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to open and close an explicit cursor in oracle?

579


Query to retrieve record for a many to many relationship ?

2081


Can we save images in a database and if yes, how?

594


How to convert a string to a date in oracle database?

542


How to pass a cursor variable to a procedure?

562






State any two functions of oracle?

636


What is a table index in oracle?

632


How is it different from a normal table?

582


What suggestions do you have to reduce the network traffic?

549


What is ceil and floor in oracle?

579


How to create a table index in oracle?

662


What privilege is needed for a user to create tables in oracle?

550


How to list all tables in your schema?

609


What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

3831


Explain table?

655