What are some SQL aggregates and other built-in functions ?
The common aggregate, built-in functions are AVG, SUM, MIN, MAX, COUNT and DISTINCT.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
Explain functions as object constructors? 03.12.08
If you prefix a new with a function call creates a new object and you can call that functions with a local keyword which is attached to that object. Object prot...Explain about mixed and callback functions? 17.11.08
Mixed function indicates that the function may contain multiple types but it doesn’t form a necessary condition. Functions like call_user_func() or usort() ac...What are the built-ins used for finding Object ID functions? 27.05.08
FIND_GROUP(function) FIND_COLUMN(function)...What are the built-ins to display the user-named editor? 21.05.08
A User-named editor can be displayed programatically with built in procedure SHOW_EDITOR,EDIT_TEXTITEM independent of any particular text item....What are some characteristics of columns that benefit from indexes ? 01.04.08
Primary key and foreign key columns; columns that have unique values; columns that have aggregates computed frequently and columns used to test the existence...What is overloading?? 01.05.07
With the C++ language, you can overload functions and operators. Overloading is the practice of supplying more than one definition for a given function name in...On which techology is integration broker built? 21.08.06
Usually the brokers like WebSphere ICS,WAS are built on J2EE technology....What are the advantages of the functions? 22.03.06
Debugging is easier It is easier to understand the logic involved in the program Testing is easier Recursive call is possible Irrelevant details in the us...What is Web application 11.03.06
An application written for the Internet, including those built with Java technologies such as JavaServer Pages and servlets, as well as those built with non-Jav...What is a protocol class? 09.03.06
An abstract class is a protocol class if:- It neither contains nor inherits from classes that contain member data, non-virtual functions, or private (or protec...