Home arrow BrainDump arrow Page 2 - All About SQL Functions

More Aggregate Functions - BrainDump

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

If we want to see what the first record in our Name column contains, we could use the First(column) function.


Select First(Name)

From Employees

This will result in the following:

  Darth Brooks

We could also sort the table first if we wanted to, allowing us to get the first alphabetical person in the table:


Select First(Name)

From Employees

Order by Name

This would return:

  Baklava

Similarly, we could use the Last(column) Function to retrieve the last piece of data in a column:


Select Last(Position)

From Employees

This would give us:

  Hairy Co-Pilot

And again we could also sort the data before choosing the last record:


Select First(Position)

From Employees

Order by Position

Here our result would be:

  Bounty Hunter Agent



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