ParameterDetailsPARTITION BYThe field(s) that follows PARTITION BY is the one that the 'grouping' will be based on
The OVER clause determines a windows or a subset of row within a query result set. A window function can be applied to set and compute a value for each row in the set. The OVER claus...
A jQuery selectors selects or finds a DOM (document object model) element in an HTML document. It is used to select HTML elements based on id, name, types, attributes, class and etc. It is based on existing CSS selectors.
Tag: No marker, use the tag directly
Id: #id
Class: .className
Attrib...
assert expression1;
assert expression1 : expression2;
ParameterDetailsexpression1The assertion statement throws an AssertionError if this expression evaluates to false.expression2Optional. When used, AssertionErrors thrown by the assert statement have this message.
By default, assertions ...
Python offers itself not only as a popular scripting language, but also supports the object-oriented programming paradigm. Classes describe data and provide methods to manipulate that data, all encompassed under a single object. Furthermore, classes allow for abstraction by separating concrete imple...
The CASE expression is used to implement if-then logic.
CASE input_expression
WHEN compare1 THEN result1
[WHEN compare2 THEN result2]...
[ELSE resultX]
END
CASE
WHEN condition1 THEN result1
[WHEN condition2 THEN result2]...
[ELSE resultX]
END
The simple CASE expression return...
ParameterDetailsstring $toThe recipient email addressstring $subjectThe subject linestring $messageThe body of the emailstring $additional_headersOptional: headers to add to the emailstring $additional_parametersOptional: arguments to pass to the configured mail send application in the command line...
There are many situations where it is useful to return several values from a function: for example, if you want to input an item and return the price and number in stock, this functionality could be useful. There are many ways to do this in C++, and most involve the STL. However, if you wish to avoi...
empty_set = set() # initialize an empty set
literal_set = {'foo', 'bar', 'baz'} # construct a set with 3 strings inside it
set_from_list = set(['foo', 'bar', 'baz']) # call the set function for a new set
set_from_iter = set(x for x in range(30)) # use arbitrary iterables to create a set
set_f...
Classes and Objects are used to to make your code more efficient and less repetitive by grouping similar tasks.
A class is used to define the actions and data structure used to build objects. The objects are then built using this predefined structure.
class <ClassName> [ extends <Par...
variable.member_var = constant;
variable.member_function();
variable_pointer->member_var = constant;
variable_pointer->member_function();
Note that the only difference between the struct and class keywords is that by default, the member variables, member functions, and base classe...
A selector is a chain of simple selectors, separated by combinators. Selectors are case insensitive (including against elements, attributes, and attribute values).
The universal selector (*) is implicit when no element selector is supplied (i.e. *.header and .header is equivalent).
PatternMatche...
SELECT column_1 [, column_2 ]
FROM table_1
ORDER BY order_column
LIMIT row_count [OFFSET row_offset]
SELECT column_1 [, column_2 ]
FROM table_1
ORDER BY order_column
LIMIT [row_offset,] row_count
"Limit" could mean "Max number of rows in a table".
"Offset&q...
An assertion is a predicate that the presented condition must be true at the moment the assertion is encountered by the software. Most common are simple assertions, which are validated at execution time. However, static assertions are checked at compile time.
assert(expression)
static_assert(...