Tutorial by Examples: b

SELECT department, COUNT(*) AS "Man_Power" FROM employees GROUP BY department HAVING COUNT(*) >= 10; Using GROUP BY ... HAVING to filter aggregate records is analogous to using SELECT ... WHERE to filter individual records. You could also say HAVING Man_Power >= 10 since HAVIN...

Fabric is a modular mobile platform that provides useful kits you can mix to build your application. Crashlytics is a crash and issue reporting tool provided by Fabric that allows you to track and monitor your applications in detail. How to Configure Fabric-Crashlytics Step 1: Change your build....

For enabling Proguard configurations for your application you need to enable it in your module-level gradle file. You need to set the value of minifyEnabled to true. buildTypes { release { minifyEnabled true proguardFiles getDefaultProguardFile('proguard-android.t...

Example of calling an extension method as an extension and as a regular method. public Class MyClass Sub Main() 'Extension called directly on the object. Dim Version = Assembly.GetExecutingAssembly.GetVersionFromAssembly() 'Called as a regular method. ...

Create a Dictionary<TKey, TValue> from an IEnumerable<T>: using System; using System.Collections.Generic; using System.Linq; public class Fruits { public int Id { get; set; } public string Name { get; set; } } var fruits = new[] { new Fruits { Id = 8 , Nam...

<plugin> <groupId>org.apache.tomcat.maven</groupId> <artifactId>tomcat7-maven-plugin</artifactId> <version>2.1</version> <executions> <execution> <...

To be able to debug an application is very important to understand the flow of an application's logic and data. It helps solving logical bugs and adds value to the programming experience and code quality. Two popular gems for debugging are debugger (for ruby 1.9.2 and 1.9.3) and byebug (for ruby &g...

com.google.gson library needs to be added to use this code. Here is the example string: String companyDetails = {"companyName":"abcd","address":"abcdefg"} JSON strings can be parsed using below syntax in Java: JsonParser parser = new JsonParser(); Json...

If you need to sort the results of a UNION, use this pattern: ( SELECT ... ) UNION ( SELECT ... ) ORDER BY Without the parentheses, the final ORDER BY would belong to the last SELECT.

The most common mode of using TensorFlow involves first building a dataflow graph of TensorFlow operators (like tf.constant() and tf.matmul(), then running steps by calling the tf.Session.run() method in a loop (e.g. a training loop). A common source of memory leaks is where the training loop conta...

There are several scopes that are available only in a web-aware application context: request - new bean instance is created per HTTP request session - new bean instance is created per HTTP session application - new bean instance is created per ServletContext globalSession - new bean instance i...

In [188]: s = pd.Series(["a","b","c","a","c"], dtype="category") In [189]: s Out[189]: 0 a 1 b 2 c 3 a 4 c dtype: category Categories (3, object): [a, b, c] In [190]: df = pd.DataFrame({"A":["a&q...

One variable per declaration (and at most one declaration per line) Square brackets of arrays should be at the type (String[] args) and not on the variable (String args[]). Declare a local variable right before it is first used, and initialize it as close to the declaration as possible.

Runnable r = () -> System.out.println("Hello World"); Supplier<String> c = () -> "Hello World"; // Collection::contains is a simple unary method and its behavior is // clear from the context. A method reference is preferred here. appendFilter(goodStrings::cont...

Methods in Go are just like functions, except they have receiver. Usually receiver is some kind of struct or type. package main import ( "fmt" ) type Employee struct { Name string Age int Rank int } func (empl *Employee) Promote() { empl.Rank++ } ...

context.lineCap=capStyle // butt (default), round, square Sets the cap style of line starting points and ending points. butt, the default lineCap style, shows squared caps that do not extend beyond the line's starting and ending points. round, shows rounded caps that extend beyond the ...

context.lineJoin=joinStyle // miter (default), round, bevel Sets the style used to connect adjoining line segments. miter, the default, joins line segments with a sharp joint. round, joins line segments with a rounded joint. bevel, joins line segments with a blunted joint. <!doctype...

context.strokeStyle=color Sets the color that will be used to stroke the outline of the current path. These are color options (these must be quoted): A CSS named color, for example context.strokeStyle='red' A hex color, for example context.strokeStyle='#FF0000' An RGB color, for e...

context.fillStyle=color Sets the color that will be used to fill the interior of the current path. These are color options (these must be quoted): A CSS named color, for example context.fillStyle='red' A hex color, for example context.fillStyle='#FF0000' An RGB color, for example ...

context.lineWidth=lineWidth Sets the width of the line that will stroke the outline of the path <!doctype html> <html> <head> <style> body{ background-color:white; } #canvas{border:1px solid red; } </style> <script> window.onload=(function(){...