Interested to Buy Any Domain ? << Click Here >> for more details...
Which one of the following pairs of aggregate functions do
you use with character fields?
1. COUNT(field) and MAX(field)
2. AVG(field) and COUNT(field)
3. MIN(field) and SUM(field)
4. AVG(field) and MAX(field)
5. COUNT(field) and SUM(field)
- 6 Answers
- 16006 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / menan
COUNT(field) and MAX(field)
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How do you sort in sql?
What are local and global variables and their differences?
What are the different types of constraints?
Sql technical questions
What is the need of a partition key?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What are the key differences between SQL and PL SQL?
How many primary keys can a table have?
How do you use a while loop in pl sql?
explain the advantages and disadvantages of stored procedure? : Sql dba
What is the current version of sql?
Do we need to create index on primary key?
What is rank () in sql?
when MSQL8.0 is in market
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
