The PostgreSQL COUNT function counts number of rows or non-NULL values against a specific column from a table.
May 3, 2013
·
9:00 AM
This document discusses how to create database in PostgreSQL using command line, pgAdmin III and phppgAdmin. For ease of understanding, each process is complemented by screenshots taken while doing.
May 3, 2013
·
9:00 AM
This document discusses how to create table in PostgreSQL using command line, pgAdmin III and phppgAdmin. For ease of understanding, each process is complemented by screenshots taken while doing.
May 3, 2013
·
9:00 AM
This document discusses PostgreSQL Data Types. While creating table, for each column, you specify a data type, i.e. what kind of data you want to store.
May 3, 2013
·
9:00 AM
This document discusses how to delete data of a table using PostgreSQL DELETE command.
May 3, 2013
·
9:00 AM
The PostgreSQL DISTINCT clause is used with SELECT statement to suppress duplicate values if any in a column. After execute a select statement the resultant table returns all rows according to the...
May 3, 2013
·
9:00 AM
A FOREIGN KEY constraint contain the value in a column or combination of columns which must be appearing in the same column or group of columns in another table.
May 3, 2013
·
9:00 AM
The group by clause is used to divide the rows in a table into smaller groups that have the same values in the specified columns. This clause is used with SELECT statement to combine a group of...
May 3, 2013
·
9:00 AM
The HAVING clause is used to specify which individual group(s) are to be displayed, that is , the desire groups that you return on the basis of aggregate functions.
May 3, 2013
·
9:00 AM
This document discusses how to insert data into a table using PostgreSQL INSERT command. We have also covered how to do the same using PHP-PostgreSQL.KJVQCSV69JFX
May 3, 2013
·
9:00 AM
