Home arrow BrainDump arrow SQL: Functioning in the Real World

SQL: Functioning in the Real World

A couple of months or so ago, I began talking about SQL functions and what they're used for. This article picks up where I left off. It defines the two types of functions, and begins to explain them in great detail.

TABLE OF CONTENTS:
  1. SQL: Functioning in the Real World
  2. What You Talkin Bout Willis?
  3. Count
  4. Count Distinct
  5. Minimum and Maximum
By: James Payne
Rating: starstarstarstarstar / 1
December 10, 2007

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

Functioning in the Real World

Let's face it, none of us function the way we want to in the real world. Sure, slap a copy of myself in the Sims and the next thing you know I am an in-shape, good looking, millionaire writer with oodles of time, a bevy of chicks from the neighborhood dropping by (and some dudes too, no matter how often I lock the door). I also have a hip house, a sauna, and a soda machine in my make believe Sim world.

Then there's me in the real world. On a fast track to being the world's fattest man (look out Guinness here I come), driving a car with no air conditioner in South Florida (aka, the Sun), and the only females that come to my door are trying to sell me cookies.

And if you are reading this article on Saturday, then guess what: you're in the same boat as me. But never fear. SQL, just like Tony Robbins, can help you out.

We left off last time with the promise of covering our good ole' pal the Function. In SQL, functions are used for counting and calculations and for saving lazy programmers time. There are two types of functions: Aggregate Functions and Scalar Functions. In this article we will discuss most of the Aggregates, such as how to get the average value of a column, count the values in a column and total them.

We'll also learn how to find both the minimum and maximum values in a column, using the min and max functions respectively. There's a lot of learnin' to do, so let's get started.



 
 
>>> 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: