The GROUP BY statement is used in conjunction with the aggregate functions to group the result-set by one or more columns.
maurice.mutuku answered the question on April 12, 2018 at 08:01
- What is the purpose of "LAST" SQL function?(Solved)
Explain the purpose of "LAST" SQL function.
Date posted: April 12, 2018. Answers (1)
- What is the purpose of "FIRST" SQL function?(Solved)
Discuss the purpose of "FIRST" SQL function.
Date posted: April 12, 2018. Answers (1)
- What is the meaning and use of <> operator in queries?(Solved)
Explain the meaning and use of <> operator in queries.
Date posted: April 12, 2018. Answers (1)
- What is the meaning and use of LIKE operator in queries?(Solved)
Explain the meaning and use of LIKE operator in queries.
Date posted: April 12, 2018. Answers (1)
- What is the meaning and use of IS Not Null operator in queries?(Solved)
Explain the meaning and use of IS Not Null operator in queries.
Date posted: April 12, 2018. Answers (1)
- What is the meaning and the use of IS Null operator in queries?(Solved)
Explain the meaning and the use of IS Null operator in queries.
Date posted: April 12, 2018. Answers (1)
- What is the meaning and the use of AND operator in queries?(Solved)
Explain the meaning and the use of AND operator in queries.
Date posted: April 12, 2018. Answers (1)
- What is the meaning and the use of OR operator in queries?(Solved)
Discuss the meaning and use of OR operator in queries.
Date posted: April 12, 2018. Answers (1)
- What is the process of adding a calculated query in the field marked B that will calculate the average mark of a student who does...(Solved)
Discuss the process of adding a calculated query in the field marked B that will calculate the average mark of a student who does two CATs namely English and Kiswahili.
Date posted: April 12, 2018. Answers (1)
- What are the stages of activating a calculation for TOTAL sum of cash collected in a FeePayment field?(Solved)
Write the stages of activating a calculation for TOTAL sum of cash collected in a FeePayment field.
Date posted: April 12, 2018. Answers (1)
- How can you write a select query criterion statement that could be used to select data from a "DueDate" field for deliveries placed after 8th...(Solved)
Write a select query criterion statement that could be used to select data from a "DueDate" field for deliveries placed after 8th Dec 2010.
Date posted: April 12, 2018. Answers (1)
- What are the major types of queries in a database?(Solved)
Discuss the major types of queries in a database.
Date posted: April 12, 2018. Answers (1)
- Why would you use queries in databases?(Solved)
Give reasons why you would use queries in databases.
Date posted: April 12, 2018. Answers (1)
- State the applications of digital cameras(Solved)
State the applications of digital cameras.
Date posted: April 11, 2018. Answers (1)
- Giving examples, describe the various classifications of input devices(Solved)
Giving examples, describe the various classifications of input devices
Date posted: April 11, 2018. Answers (1)
- What is a datasheet?(Solved)
Define the term datasheet.
Date posted: April 11, 2018. Answers (1)
- What is a switchboard?(Solved)
Define switchboard.
Date posted: April 11, 2018. Answers (1)
- What are the main categories of controls found used in Ms Access?(Solved)
Discuss the main categories of controls found used in Ms Access.
Date posted: April 11, 2018. Answers (1)
- What is "Control" as used in form design?(Solved)
Define the term "Control" as used in form design
Date posted: April 11, 2018. Answers (1)
- What are the major sections of a form in design view?(Solved)
Discuss the major sections of a form in a design view.
Date posted: April 11, 2018. Answers (1)