Tutorial by Examples: v

In tables recording events there is often a datetime field recording the time an event happened. Finding the single most recent event can be difficult because it's always possible that two events were recorded with exactly identical timestamps. You can use row_number() over (order by ...) to make su...

While chrome browser is open to any tab (except welcome tabs) you have three options to open Chrome Dev Tools: Keyboard: Type command ⌘+option+i Browser Menu: Click 'Menu' > 'More Tools' > 'Developer Tools' Program Menu (at top of your screen): Click 'View' > 'Developer' > 'Develope...

You use the FIRST_VALUE function to determine the first value in an ordered result set, which you identify using a scalar expression. SELECT StateProvinceID, Name, TaxRate,        FIRST_VALUE(StateProvinceID)         OVER(ORDER BY TaxRate ASC) AS FirstValue FROM SalesTaxRate; In this example,...

The LAST_VALUE function provides the last value in an ordered result set, which you specify using a scalar expression. SELECT TerritoryID, StartDate, BusinessentityID,        LAST_VALUE(BusinessentityID)          OVER(ORDER BY TerritoryID) AS LastValue FROM SalesTerritoryHistory; This example...

When asking Apache Spark related questions please include following information Apache Spark version used by the client and Spark deployment if applicable. For API related questions major (1.6, 2.0, 2.1 etc.) is typically sufficient, for questions concerning possible bugs always use full version ...

What is floating point? There are two types of numbers: fixed point where a certain number of digits are available before and after the radix point. floating point where a certain number of digits are available for the mantissa and for the exponent. An example using decimal digits with three...

An example of a configuration function in SQL is the @@SERVERNAME function. This function provides the name of the local server that's running SQL. SELECT @@SERVERNAME AS 'Server' ServerSQL064 In SQL, most data conversions occur implicitly, without any user intervention. To perform any convers...

var providerName = "System.Data.SqlClient"; //Oracle.ManagedDataAccess.Client, IBM.Data.DB2 var connectionString = "{your-connection-string}"; //you will probably get the above two values in the ConnectionStringSettings object from .config file var factory = DbProviderFac...

The useGravity property of a RigidBody controls whether gravity affects it or not. If set to false the RigidBody will behave as if in outer space (without a constant force being applied to it in some direction). GetComponent<RigidBody>().useGravity = false; It is very useful in the situati...

The abstract class IntentService is a base class for services, which run in the background without any user interface. Therefore, in order to update the UI, we have to make use of a receiver, which may be either a BroadcastReceiver or a ResultReceiver: A BroadcastReceiver should be used if your s...

ng-view is a directive used with $route to render a partial view in the main page layout. Here in this example, Index.html is our main file and when user lands on "/" route the templateURL home.html will be rendered in Index.html where ng-view is mentioned. angular.module('ngApp', ['ngRou...

In Pharo everything is an object, and every object responds to messages. So if you evaluate the following code Object subclass: #MyClass the object Object will create for you its subclass called MyClass. If you don't have any particular superclass in your mind it's advised to subclass from Objec...

From anywhere in Vim, execute :help :help. This will open a horizontally split window with the manual page for the :help command. :help by itself will take you to the Table of Contents for the manual itself. Vim's help files are navigable like regular files (you can search for keywords within a fil...

For example if the input is: Output should be false: As 4 in the left sub-tree is greater than the root value(3) If the input is: Output should be true

with Ada.Text_IO; procedure Image_And_Value is type Fruit is (Banana, Orange, Pear); X : Fruit := Orange; begin Ada.Text_IO.Put_Line (Boolean'Image (Fruit'Value (Fruit'Image (X)) = X and Fruit'Image (Fruit'Value ("ORANGE")) = "ORANGE"));...

A Vector3 structure can be created in several ways. Vector3 is a struct, and as such, will typically need to be instantiated before use. Constructors There are three built in constructors for instantiating a Vector3. ConstructorResultnew Vector3()Creates a Vector3 structure with co-ordinates of...

The Vector3 structure contains some static functions that can provide utility when we wish to apply movement to the Vector3. Lerp and LerpUnclamped The lerp functions provide movement between two co-ordinates based off a provided fraction. Where Lerp will only permit movement between the two co-or...

Setup ActiveMQ Download a ActiveMQ distribution from activemq.apache.org and unpack it somewhere You can start the server immediately, running unsecured on localhost, using the script bin/activemq When it is running, you can access your local server's console on http://localhost:8161/admin/ Co...

Activity lifecycle is quite more complex. As you know Activity is single page in the Android app where user can perform interaction with it. On the diagram below you can see how Android Activity lifecycle looks like: As you can see there is specific flow of Activity lifecycle. In the mobile appl...

Consider the Binary Tree: Pre-order traversal(root) is traversing the node then left sub-tree of the node and then the right sub-tree of the node. So the pre-order traversal of above tree will be: 1 2 4 5 3 6 7 In-order traversal(root) is traversing the left sub-tree of the node then the node ...