SQL Window Functions and You

Submitted by Ezekiel Templin 2012-05-23 16:05:18 UTC
Source:  http://blog.hashrocket.com/posts/sql-window-functions

Referenced projects

Ruby on Rails

Ruby on Rails is a full-stack web framework optimized for programmer happiness and sustainable productivity. It encourages beautiful code by favoring convention over configuration.

Rubygem rails

Total Downloads
45214789
Releases
236
Current Version
4.2.1.rc1
Released
2015-02-20 00:00:00 UTC
First Release
2004-10-25 04:00:00 UTC

Github rails/rails

Watchers
25062
Forks
9780
Development activity
Very active
Last commit
2015-02-24 02:02:52 UTC
Contributors
30
Issues

pg

Pg is the Ruby interface to the {PostgreSQL RDBMS}[http://www.postgresql.org/]. It works with {PostgreSQL 8.4 and later}[http://www.postgresql.org/support/versioning/]. A small example usage: #!/usr/bin/env ruby require 'pg' # Output a table of current connections to the DB conn = PG.connect( dbname: 'sales' ) conn.exec( "SELECT * FROM pg_stat_activity" ) do |result| puts " PID | User | Query" result.each do |row| puts " %7d | %-16s | %s " % row.values_at('procpid', 'usename', 'current_query') end end

Rubygem pg

Total Downloads
13724369
Releases
46
Current Version
0.18.0
Released
2015-01-05 00:00:00 UTC
First Release
2008-01-28 08:00:00 UTC
×

In order to continue, you must be signed in using your Github account.

If you're signing in using this account for the first time Github will ask for your permission to give access to your public user data to the Ruby Toolbox.

Although the Github Authorization page does not mention it, the request includes read-only access to your verified email address (user:email OAuth scope). This is neccessary so there's a way to notify you about comments, information about your accepted project edits and the like. You can review your notification settings on your account page once you're signed in.