nonsleepr

-- Via http://forums.teradata.com/forum/database/dense-rank

SELECT
    department_number,
    /*** Syntax not implemented in Teradata ***/
    DENSE_RANK() OVER (PARTITION BY department_number ORDER BY salary_amount),
    last_name,
    salary_amount
FROM employee;

nonsleepr

#!/bin/bash
 
#
# Usage:
#    > futurelearn_dl.sh [email protected] password course-name week-id
# Where *[email protected]* and *password* - your credentials
# ,*course-name* is the name from URL
# and *week-id* is the ID from the URL
#
# E.g. To download all videos from the page: https://www.futurelearn.com/courses/corpus-linguistics/todo/238

nonsleepr

nonsleepr

#!/usr/bin/bash

# Requires:
# - xmlstarlet
# - gawk
# - wget
# - xargs

wget -qO - http://techtv.mit.edu/collections/compu-camera/videos.rss | \
xmlstarlet sel -t -m '//item' -v 'link' -o ',' -v 'enclosure/@url' -n | \