http://www.jitbit.com/news/181-jitbits-sql-interview-questions/
employees
- employee_id
- department_id
- boss_id
- name
import java.nio.charset.StandardCharsets | |
import java.nio.charset.Charset | |
def string = 'おっぱい - うほ' | |
def bytes = string.getBytes(StandardCharsets.UTF_8) | |
def toString = {byte[] bs, Charset cs -> new String(bs, cs) } | |
def toBytes = {String s, Charset cs -> s.getBytes(cs) } |
package module1.exercise.discount; | |
import java.util.List; | |
public class Basket { | |
private double amount; | |
private List<Item> items; | |
public Basket(List<Item> itemss) { |
package module2.exercise.mocks; | |
import java.util.Calendar; | |
public class Invoice { | |
private Calendar date; | |
private String customer; | |
private double amount; | |
public Invoice(Calendar date, String customer, double amount) { |
-- JitBit SQL Interview Questions (Posted on Hacker News) | |
-- http://www.jitbit.com/news/181-jitbits-sql-interview-questions/?utm_source=hackernewsletter&utm_medium=email | |
-- Schema: | |
-- employees table | |
-- EmployeeID | |
-- DepartmentID | |
-- BossID | |
-- Name | |
-- Salary |
http://www.jitbit.com/news/181-jitbits-sql-interview-questions/
employees
While using git-bash, you may need the zip command to zip files. Then you will get error like “command not found“. This is because git-bash is really just a cut down version of mingw. Fortunately you can manually install the command yourself, not only zip, but any command you can get from gnuwin32.
Here are the steps you can follow.
Go to the following link https://sourceforge.net/projects/gnuwin32/files/
Find out whatever command you are missing Here I need zip and bzip2 for zip command. Because zip command relies on bzip2.dll to run. Otherwise you will get error “error while loading shared libraries: ?: cannot open shared object file: No such file or directory”.
<?xml version="1.0" encoding="UTF-8"?> | |
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" | |
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> | |
<modelVersion>4.0.0</modelVersion> | |
<groupId></groupId> | |
<artifactId></artifactId> | |
<version>1.0.0-SNAPSHOT</version> |
Code is clean if it can be understood easily – by everyone on the team. Clean code can be read and enhanced by a developer other than its original author. With understandability comes readability, changeability, extensibility and maintainability.
/* How to calculate postgreSQL database size in disk ? */ | |
SELECT pg_size_pretty(pg_database_size('thedbname')); | |
/* Calculate size of a table including or excluding the index */ | |
SELECT pg_size_pretty(pg_total_relation_size('big_table')); | |
SELECT pg_size_pretty(pg_relation_size('big_table')); /* without index */ | |
/* See indexes on a table with `\d tablename` */ |