Convert datetime to a varchar using a 2 digit year in SQL
How to pivot and create a new table from multiple data rows
How to select top rows from a table without hard coding the top value
Join two tables based on same start and end time
Return the last version of data row from a table
Returning only the rows that have a count greater than N in a table that contains multiple versions of data rows
Returning only the rows that have a count less than N in a table that contains multiple versions of data rows
Returning the first version of the data row from a table that contains multiple versions of data rows
Memory management and the Stack
A stack organizes a set of data elements in a Last In, First Out ( LIFO ) manner. The three basic operations on a stack are: push which adds a new element to the top of the stack, pop which removes an element from the top of the stack, and a check to see if the stack is empty. ...
Variable Scoping in Go
Variables that are declared inside a function or a block are called local variables. They can be used only by statements that are inside that function or block of code. Local variables are not known to functions outside their own. The following example uses local variables. ...
A variable definition tells the compiler where and how much storage to create for the variable. A variable definition specifies a data type and contains a list of one or more variables of that type. There are two types of variable declarations, explicitly typed variables and implicitly typed variables. Below is an example of an explicitly typed variable ...
We can tuple just like we create a list, except that we use regular brackets instead of square brackets. If we create a tuple with a single item, we need to include a comma at the end, otherwise we'll end up with a string. Tuples can hold different data types including lists so we can have a tuple with an element being a list. We access the values in a tuple by using the variable name with an index value enclosed in square brackets. We can also pick a range of values by using two indices se ...