Alexeytur

select 
table.*,
table.number - LEAD(table.number) OVER (ORDER BY table.name)
from table
where Dictionary='Dict1'
ORDER BY table.name

def dict_get_recursive(source, path):
	current_dict = source
	for path_idx, path_key in enumerate(path):	
		if path_idx == len(path)-1:
			return current_dict.get(path_key, None)
		
		current_dict = current_dict.get(path_key, None)
		if current_dict is None:
			return None
			
new_dic['Name_1'] = dict_get_recursive(source_1,['key_1','key_2','key_3'])
new_dic['Name_2'] = dict_get_recursive(source_2,['key_1','key_2'])
new_dic['Name_3'] = dict_get_recursive(source_1,['key_1','key_2','key_3','key_4'])

for (int i = 0, j = (diagNum == 0) ? N - 1 : N - diagNum - 1; j >= 0; ++i, --j)

r = requests.get('https://api.github.com/events').json()

public static bool CheckWords(string text)
{
    List<string[]> lines = new List<string[]>();
    string[] arr_lines = text.Split(new string[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries );
    foreach (string line in arr_lines)
    {
        string[] arr_words = line.Split(' ');
        lines.Add(arr_words);
    }

    for (int current_line_num = 0; current_line_num < lines.Count - 1; current_line_num++)
    {
        for (int current_word_num = 0; current_word_num < lines[current_line_num].Length; current_word_num++)
        {
            if (current_word_num < lines[current_line_num + 1].Length
                && lines[current_line_num][current_word_num] == lines[current_line_num + 1][current_word_num])
            {
                return true; // совпадение!

            }
        }
    }

    return false;
}

public static void TestTexts()
{
    string text =
        @"This sentence is pretty long and
        this sentence is also a test";
    bool res = CheckWords(text);

    string text2 =
        @"This sentence also shouldn't
        match as this has no words
        below";
    bool res2 = CheckWords(text2);
}

SELECT id FROM test WHERE id NOT IN (<список цифр>)