You are here

Database

Left join, right join, outer join, inner join

As per the documentation: FROM (Transact-SQL):

Blog: 

How to select records with given interval

How to select records with every N records' interval?
Using the rank(), this is the the snipet, for Oracle:
Table name: tableabc,
---------------------
id  |  time  |   test
---------------------
SELECT id, rank() over (partition by 1 order by time) as interval, test
                                   FROM  tableabc 

How to install Postgre database into Xampp

How to install pgsql into Xampp:

1. install pgsql under user/xampp/pgsql/9.1/
You can choose other version

and download phpPgAdmin as you will, copy it under user\xampp\phpPgAdmin

2. edit user\xampp\apache\conf\extra\httpd-xampp.conf

....

Alias /phppgadmin "user/xampp/phpPgAdmin/"

AllowOverride AuthConfig
Order allow,deny
Allow from all

3. edit user\xampp\phpPgAdmin\conf\config.inc.php

$conf['servers'][0]['host'] = 'localhost';

$conf['extra_login_security'] = false;

Blog: 
Subscribe to RSS - Database