1. SUM, AVG, MIN, and MAX can only be used with numeric columns.



Ask Your Doubts Here

Type in
(Press Ctrl+g to toggle between English and the chosen language)

Comments

Show Similar Question And Answers
QA->P can do a work in the same time in which Q and R together can do it. If P and Q work together, the work can be completed in 10 days. R alone needs 50 days to complete the same work. then Q alone can do it in....
QA->A and B can do a work in 10 days, B and C can do it in 12 days, C and A can do it in 15 days. If A, B, and C work together, they will complete the work in:....
QA->A and B can do a work in 10 days. B and C can do it in 12 days. C and A can do it in 15 days. If A, B, and C work together, then the work will complete....
QA->P,Q and R together earn Rs.1620 in 9 days. P and R can earn Rs.600 in 5 days. Q and R in 7 days can earn Rs. How much amount does R can earn per day?....
QA->P can do a work in 24 days. Q can do the same work in 9 days and R can do the same in 12 days. Q and R start the work and leave after 3 days. P finishes the remaining work in --- days.....
MCQ->SUM, AVG, MIN, and MAX can only be used with numeric columns.....
MCQ->Which of the following are valid calls to Math.max? Math.max(1,4) Math.max(2.3, 5) Math.max(1, 3, 5, 7) Math.max(-1.5, -2.8f)....
MCQ->SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.....
MCQ->Point out the error in the program (in Turbo-C). #include<stdio.h> #define MAX 128 int main() { const int max=128; char array[max]; char string[MAX]; array[0] = string[0] = 'A'; printf("%c %c\n", array[0], string[0]); return 0; }....
MCQ->Inverter 74 LS04 has following specifications I0H max = - 0.4 mA, I0L max = 8 mA, IIH max = 20 μA, IIL max = 0.1 mA The fan out of this inverter is....
Terms And Service:We do not guarantee the accuracy of available data ..We Provide Information On Public Data.. Please consult an expert before using this data for commercial or personal use | Powered By:Omega Web Solutions
© 2002-2017 Omega Education PVT LTD...Privacy | Terms And Conditions
Question ANSWER With Solution