What are some of the standard SQL functions that can be used in the SELECT clause?
What will be an ideal response?
The standard functions can be broken down into 4 categories: Mathematical, String, Date and Analytical. Mathematical functions include Min, Max, Count, Sum, Round, Trunc and Mod. String functions include lower, upper, initcap, concat, substr and coalesce. Date functions are used for converting dates and calculating dates and include next_day, add_months and months_between. Top (to find the top n values) is one of the analytical functions.
You might also like to view...
Which of the following is the best argument against the use of negative accounts receivable confirmation requests?
A. Recipients are likely to feel that in reality the confirmation is a subtle request for payment. B. The inference drawn from receiving no reply may not be correct. C. The cost-per-response is excessively high. D. There is no way of knowing if the intended recipients received them.
Merchant Corporation provides plumbing services. Transactions of Merchant during the first year of operations are given below
a) Received $12,000 cash and issued common stock to Sharon b) Paid $1,600 cash for equipment to be used for plumbing repairs. c) Borrowed $14,000 from a local bank and deposited the money in the checking account. d) Paid $600 rent for the year. e) Purchased $200 of office supplies by cash. f) Completed a plumbing repair project for a local lawyer and received $3,000 cash. Calculate the amount of total liabilities at the end of the first year. A) $14,000 B) $12,000 C) $24,400 D) $3,000
If travel between departments is restricted to the aisles shown in Figure 1, what is the total weighted-distance (wd) score for the block plan shown in Figure 1?
A) less than or equal to 30 B) greater than 30 but less than or equal to 60 C) greater than 60 but less than or equal to 90 D) greater than 90
When using the indirect method to calculate and report net cash provided or used by operating activities, which of the following is subtracted from net income?
A. Decrease in merchandise inventory. B. Amortization of intangible assets. C. Decrease in income taxes payable. D. Bad debts expense. E. Depreciation expense.