Get premium membership and access questions with answers, video lessons as well as revision papers.
The Date function will display records from the past 30 days prior to the current date.
maurice.mutuku answered the question on April 12, 2018 at 08:22
- What is the description of Full Name:[FirstName]&" "&[LastName] expression as used in queries?(Solved)
Write down the description of Full Name:[FirstName]&" "&[LastName] expression as used in queries.
Date posted: April 12, 2018. Answers (1)
- What is the purpose of "COUNT" SQL function?(Solved)
Explain the purpose of "COUNT" SQL function.
Date posted: April 12, 2018. Answers (1)
- What is the purpose of "MAX" SQL function?(Solved)
Describe the purpose of "MAX" SQL function.
Date posted: April 12, 2018. Answers (1)
- What is the purpose of "MIN" SQL function?(Solved)
Explain the purpose of "MIN" SQL function.
Date posted: April 12, 2018. Answers (1)
- What is the purpose of "AVG" SQL function?(Solved)
Explain the purpose of "AVG" SQL function.
Date posted: April 12, 2018. Answers (1)
- What is the purpose of "SUM" SQL function?(Solved)
Explain the purpose of "SUM" SQL function.
Date posted: April 12, 2018. Answers (1)
- What is the purpose of of "GROUP BY" SQL function?(Solved)
Describe the purpose of "GROUP BY" SQL function.
Date posted: April 12, 2018. Answers (1)
- 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)