Tutorial by Examples: er

Create a stream by selecting the elements from a stream that pass a certain condition is called filtering var newReleases = [ [ "id": 70111470, "title": "Die Hard", "boxart": "http://cdn-0.nflximg.com/images/2891/DieHard.j...

Query syntax and method syntax are semantically identical, but many people find query syntax simpler and easier to read. Let’s say we need to retrieve all even items ordered in ascending order from a collection of numbers. C#: int[] numbers = { 0, 1, 2, 3, 4, 5, 6 }; // Query syntax: IEnumerab...

A HAVING clause filters the results of a GROUP BY expression. Note: The following examples are using the Library example database. Examples: Return all authors that wrote more than one book (live example). SELECT a.Id, a.Name, COUNT(*) BooksWritten FROM BooksAuthors ba INNER JOIN Aut...

We can use 1,2,3.. to determine the type of order: SELECT * FROM DEPT ORDER BY CASE DEPARTMENT WHEN 'MARKETING' THEN 1 WHEN 'SALES' THEN 2 WHEN 'RESEARCH' THEN 3 WHEN 'INNOVATION' THEN 4 ELSE 5 END, CITY IDREGIONCITYDEPARTMENTEMPLOYEES_N...

You can use any ruby technique to dynamically create a list of files to load. Illustration of globbing for files starting with test, loaded in alphabetical order. Dir[ "#{ __dir__ }**/test*.rb" ) ].sort.each do |source| require_relative source end

DECLARE @DateFrom DATETIME = '2016-06-01 06:00' DECLARE @DateTo DATETIME = '2016-07-01 06:00' DECLARE @IntervalDays INT = 7 -- Transition Sequence = Rest & Relax into Day Shift into Night Shift -- RR (Rest & Relax) = 1 -- DS (Day Shift) = 2 -- NS (Night Shift) = 3 ;WITH roster AS ...

This function returns the floating-point remainder of the division of x/y. The returned value has the same sign as x. #include <math.h> /* for fmod() */ #include <stdio.h> /* for printf() */ int main(void) { double x = 10.0; double y = 5.1; double modulus = fmod(x,...

Requirements: Docker can be installed on any Linux with a kernel of at least version 3.10. Docker is supported on the following 64-bit versions of Ubuntu Linux: Ubuntu Xenial 16.04 (LTS) Ubuntu Wily 15.10 Ubuntu Trusty 14.04 (LTS) Ubuntu Precise 12.04 (LTS) Easy Installation Note: Installi...

Sometimes we would like to pass into the template a template type without fixing its values. This is what template template parameters are created for. Very simple template template parameter examples: template <class T> struct Tag1 { }; template <class T> struct Tag2 { }; templ...

Python classes support properties, which look like regular object variables, but with the possibility of attaching custom behavior and documentation. class MyClass(object): def __init__(self): self._my_string = "" @property def string(self): "&...

Elixir matches a function call to its body based on the value of its arguments. defmodule Math do def factorial(0): do: 1 def factorial(n): do: n * factorial(n - 1) end Here, factorial of positive numbers matches the second clause, while factorial(0) matches the first. (ignoring negat...

You can pass default parameters to any named function using the syntax: param \\ value: defmodule Example do def func(p1, p2 \\ 2) do IO.inspect [p1, p2] end end Example.func("a") # => ["a", 2] Example.func("b", 4) # => ["b", ...

C99 Type Declaration A structure with at least one member may additionally contain a single array member of unspecified length at the end of the structure. This is called a flexible array member: struct ex1 { size_t foo; int flex[]; }; struct ex2_header { int foo; char...

Autoboxing can come at a substantial memory overhead. For example: Map<Integer, Integer> square = new HashMap<Integer, Integer>(); for(int i = 256; i < 1024; i++) { square.put(i, i * i); // Autoboxing of large integers } will typically consume substantial amount of memory (...

To change password of current user just type: sudo passwd It will ask you to enter your current password: [sudo] password for <user>: And then you will be asked to enter new password: Enter new UNIX password: And finally you will be asked to re-enter your password: Retype new UNIX...

Swift //Swift let viewController = UIViewController() let navigationController = UINavigationController(rootViewController: viewController) //Objective-C UIViewController *viewController = [[UIViewController alloc] init]; UINavigationController *navigationController = [[UINavigationControlle...

//Swift let fooViewController = UIViewController() navigationController?.pushViewController(fooViewController, animated: true) //Objective-C UIViewController *fooViewController = [[UIViewController alloc] init]; [navigationController pushViewController:fooViewController animated:YES];

As we know that we should use synchronized keyword to make execution of a method or block exclusive. But few of us may not be aware of one more important aspect of using synchronized and volatile keyword: apart from making a unit of code atomic, it also provides read / write barrier. What is this re...

It is common within applications to need to have code like this : a = a + 1 or a = a * 2 There is an effective shortcut for these in place operations : a += 1 # and a *= 2 Any mathematic operator can be used before the '=' character to make an inplace operation : -= decrement the va...

All of the Bitwise operators (except ~) have their own in place versions a = 0b001 a &= 0b010 # a = 0b000 a = 0b001 a |= 0b010 # a = 0b011 a = 0b001 a <<= 2 # a = 0b100 a = 0b100 a >>= 2 # a = 0b001 a = 0b101 a ^= 0b011 # a = 0b110