WHT ARE THE AGGREATE FUNCTIONS?

Answer Posted / gopinath

Aggregate functions are:sum,min,max,count,count distinct

Is This Answer Correct ?    15 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to drop an existing table in oracle?

592


Explain how are indexes update?

623


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

595


What is MTTR advisor in Oracle?

610


src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1181






How to connect to the server with user account: sys?

566


How to list all tables in your schema?

609


How to divide query output into groups in oracle?

563


How to select all columns of all rows from a table in oracle?

590


What is a server parameter file in oracle?

594


How to add a new column to an existing table in oracle?

588


Explain integrity constraint?

644


How to empty your oracle recycle bin?

575


Explain alias?

715


How to use subqueries with the exists operator in oracle?

608