Personal computing discussed

Moderators: SecretSquirrel, just brew it!

 
Flatland_Spider
Graphmaster Gerbil
Topic Author
Posts: 1324
Joined: Mon Sep 13, 2004 8:33 pm

Advanced SQL Resources?

Fri Oct 16, 2015 6:51 pm

Are there any resources out there that get into advanced or really advanced SQL? You know, the stuff beyond selects with a subqueries. Ideally it should target PostgreSQL or MySQL, but standard SQL will work as well.
 
PhilipMcc
Gold subscriber
Gerbil First Class
Posts: 137
Joined: Thu Feb 05, 2009 10:15 am
Location: Pittsburgh

Re: Advanced SQL Resources?

Sun Oct 18, 2015 7:43 am

I am interested to follow this thread also. There is value in reading the code of others and in trying new things for yourself.

Much of my day is spent working with Oracle so the following may not apply directly to the SQL flavors you mention. I've learned how ranking and unpivot can be very helpful. On occasion I search this on-line resource.

Who is online

Users browsing this forum: No registered users and 2 guests