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)