You are here


How to select records with given interval

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

Blog Terms: 

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\

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

$conf['extra_login_security'] = false;

Subscribe to RSS - Database