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