Yogendra Kumar yogicse

🎯

Focusing

yogicse / crosstab.sql

Created September 6, 2018 03:17 — forked from romansklenar/crosstab.sql

PostgreSQL "pivot table" example using tablefunc extension

	CREATE EXTENSION tablefunc;

	CREATE TABLE sales(year int, month int, qty int);
	INSERT INTO sales VALUES(2007, 1, 1000);
	INSERT INTO sales VALUES(2007, 2, 1500);
	INSERT INTO sales VALUES(2007, 7, 500);
	INSERT INTO sales VALUES(2007, 11, 1500);
	INSERT INTO sales VALUES(2007, 12, 2000);
	INSERT INTO sales VALUES(2008, 1, 1000);
	INSERT INTO sales VALUES(2009, 5, 2500);

Created November 28, 2016 04:20 — forked from thagxt/Magento How to get the customer login, logout, register and checkout urls.php

Magento How to get the customer login, logout, register and checkout urls

	login url
	<?php echo Mage::getUrl('customer/account/login'); ?>

	logout url
	<?php echo Mage::getUrl('customer/account/logout'); ?>

	My Account url
	<?php echo Mage::getUrl('customer/account'); ?>

	Register url