Home arrow BrainDump arrow All About SQL Functions

All About SQL Functions

In the last tutorial we left off with the SUM(column) function. In this article we will cover the remaining Aggregate Functions and the Scalar Functions. We might even make some fat jokes, some mama jokes, and as always, some nerd jokes.

TABLE OF CONTENTS:
  1. All About SQL Functions
  2. More Aggregate Functions
  3. STDEV
  4. Scalar Functions
  5. Mid(c,start[,end]
  6. Round(c,decimals)
By: James Payne
Rating: starstarstarstarstar / 8
December 17, 2007

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

For this tutorial we are going to create a new database. Since I saw the Robot Chicken and Family Guy Star Wars episodes last night, and got like four hours of sleep to boot, we will be working with a Star Wars database. I know, I know. The writing in Star Wars was atrocious. Of course to avoid a lawsuit, we will be using my own version of Star Wars, call SilverWares: The Battle of the Knives and Spoons.

Before I give you the data though, let's do a little thing I like to call back-story. The story picks up with the Spoons trying to destroy the Knives. To do so, they have created a menacing weapon, a Spork, a Spoon with the built in ability to use...the Fork. Meanwhile, the Knives have uncovered their old Fork Master Gouda, a strange smelly alien whom they hope will teach young Luke Breadslicer the ways of the Fork.

Here is the data for our new database Employees:

 

Name

Position

Salary

Side

Darth Brooks

Sith Lord/Country Singer

$10,000

Spoon

Darth Ladel

Sith Master

$100,000

Spoon

Luke Breadslicer

Fork Apprentice

$20,000

Knife

Gouda

Fork Master

$120,000

Knife

Jabba the Cup

Bounty Hunter Agent

$500,000

Neutral

Bubba Fett

Red Neck Alien Bounty Hunter

$1,000

Neutral

Dance Solo

Pilot for Hire

$40,000

Knife

Baklava

Hairy Co-Pilot

$25,000

Knife



 
 
>>> More BrainDump Articles          >>> More By James Payne
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

BRAINDUMP ARTICLES

- Apple Founder Steve Jobs Dies
- Steve Jobs` Era at Apple Ends
- Google's Chrome Developer Tool Updated
- Google's Chrome 6 Browser Brings Speed to th...
- New Open Source Update Fedora 13 is Released...
- Install Linux with Knoppix
- iPad Developers Flock To SDK 3.2
- Managing a Linux Wireless Access Point
- Maintaining a Linux Wireless Access Point
- Securing a Linux Wireless Access Point
- Configuring a Linux Wireless Access Point
- Building a Linux Wireless Access Point
- Migrating Oracle to PostgreSQL with Enterpri...
- Demystifying SELinux on Kernel 2.6
- Yahoo and Microsoft Create Ad Partnership

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: