Question

what are different types of queries ? Name some summary function and their usage .how is detailed query different from a summary query?​

Answer 1

$\large{\text{\red{A}}}{\text{\orange{N}}{\text{\green{S}}{\text{\purple{W}}{\text{\blue{E}}{\text{\pink{R}}{\text{\gray{:-}}}}}}}}$

Select queries that display individual records are called detail queries; those that summarize records are called Summary or Totals queries. Summary functions produce a summary of all records in the found set, or subsummary values for records in different groups.