Groupby In Sql Server


Posted by Admin

Groupby In Sql Server

Groupby In Sql Server

Introduction

As a precursor to the PHP and MySQL programming tutorial, it is worth understanding that one of the most powerful uses for PHP and MySQL is as a Content Management System (or CMS). The CMS is the backbone of a good interactive web site, and all the top publishing systems, from Drupal to Wordpress use some form of server side scripting and a database. More often than not, the pair that is chosen as PHP and MySQL.

It is worth pointing out, however, that other scripting languages (such as Perl, or even C) and databases (Oracle, DB2 etc.) are available, and indeed, sometimes even better than the PHP/MySQL pairing. However, these two have traditionally been chosen because PHP is easier to program in than Perl, and MySQL is a good, stable, Open Source database platform. While this might be an over-simplification, it is true that the PHP language is aimed at power and flexibility, with an easy to understand syntax, and is therefore a great place to start web programming.

What is PHP?

Following Open Source trends, PHP is a recursive acronym for PHP Hypertext Processor, and is a scripting language that allows the programmer to write code designed to be interpreted by the web server. This code can interface with back end databases, provides full programming support (decisions, loops, variables, and so on), and is commonly used to generate HTML.