gabhi

####top nth salary

SELECT * FROM one as A WHERE ( n ) = ( SELECT COUNT(DISTINCT(b.salary)) FROM one as B WHERE B.salary >= A.salary )

SELECT DISTINCT(a.salary) FROM employee a WHERE 2 = (SELECT COUNT( DISTINCT(b.salary) )FROM employee b WHERE a.salary <= b.salary ) ;

2nd highest salary

gabhi

#!/usr/bin/env python

import csv
import Queue
import threading
import ystockquote as ys


def gen_info_list(tickers, start, end):
    '''

gabhi

ps -ef | grep cassandra | grep -v grep | awk '{print $2}' | xargs kill -9

gabhi

import sys
from urllib import urlencode
import requests
from urlparse import urlparse, parse_qs
from random import choice
import re


self_id = None # your facebook id here
utc_bday = None # utc timestamp of your birthday

gabhi

#   Let min = arr[0]
#   For k = 1 to length(arr):
#       If arr[k] < min, set min = arr[k]
#       If profit < arr[k] - min, set profit = arr[k] - min
#
# This is short, sweet, and uses only O(n) time and O(1) memory.  The beauty of
# this solution is that we are quite naturally led there by thinking about how
# to update our answer to the problem in response to seeing some new element.
# In fact, we could consider implementing this algorithm as a streaming
# algorithm, where at each point in time we maintain the maximum possible

gabhi

Follow link

Open DDG Env

run following command after forking and going inside the directory

duckpan server

gabhi

import org.zeroturnaround.exec.ProcessExecutor;

import java.io.IOException;
import java.util.concurrent.TimeoutException;

/**
 * Created by agaikwad on 2/26/16.
 */
public class GrepProcessIdProcessFromJava {

gabhi

import json
import pymongo
import tweepy

consumer_key = ""
consumer_secret = ""
access_key = ""
access_secret = ""

auth = tweepy.OAuthHandler(consumer_key, consumer_secret)

gabhi

import java.util.Scanner;

public class PascalTriangle {

   public static void print(int n) {
       for (int i = 0; i < n; i++) {
           for (int j = 0; j <= i; j++) {
               System.out.print(pascal(i, j) + " ");
           }
           System.out.println();

gabhi

#!/bin/bash
# Delete all containers
docker rm $(docker ps -a -q)
# Delete all images
docker rmi $(docker images -q)