Some Advanced Sql Statements And Aggregated Functions

• Download source files - 148 Kb

Introduction

        Are you bored with the same 'Insert','Delete' & 'Update Statement'?
Then it's time to move on to some advanced Sql Statements and Functions.
Here I have written an application illustrating different advanced
Sql Statements and functions which will be useful to any level of database
programmer.
        This application will provide you sql statements to backup your database,
copy records from one table to another,adding/deleting fields from tables,
creating and droping tables,creating indices,creating joins and so on.
I have also illustrated some aggregrated sql functions like sum,count,
avg,min/max ...
        Other additional statements like Last,In,Union,Distinct,Between...And,
Alias,And..Or,Select...Into,Insert...Select are also included.

        I have also provided some brief hints on each sql statements/functions.

Using The Application

        Drop down the combo-box to select different Sql Statements as you execute them.