Archive for the ‘SQL’ Category

DISTINCT / GROUP BY PERFORMANCE

Posted by: siamnobita on 05/25/2016

Dynamic SQL Pivoting

Posted by: siamnobita on 03/16/2016

NO_DATA_FOUND in SQL statements

Posted by: siamnobita on 09/24/2015

Index and not equal

Posted by: siamnobita on 02/25/2015

Pseudocolumn

Posted by: siamnobita on 11/25/2011

Finding continuous number

Posted by: siamnobita on 06/17/2010

Guess Work

Posted by: siamnobita on 05/24/2010

Function to count weekend (2)

Posted by: siamnobita on 12/29/2009

Function to count weekend

Posted by: siamnobita on 12/29/2009

Tuning Function Part II

Posted by: siamnobita on 06/20/2009