Archive for the 'SQL' Category
Finally I have my own domain name. Please click HERE to read this same post on my new site. Thanks!
i remember there is one time where i have to edit an old module where in the date field in sql is not a date data type but instead, it is a char type… they did [...]
Filed under: SQL | 7 Comments
Tags: month, SQL date, year
Finally I have my own domain name. Please click HERE to read this same post on my new site. Thanks!
I had a query once that contains a divide operation….
SELECT x, y, ROUND(x/y) as quotient
FROM dataTbl
It always returns a correct value…
but divide by zero error occurs whenever
there is a zero(0) not NULL value in y column…
now, what i [...]
Filed under: SQL | 5 Comments
Tags: divide by zero, divide error, SQL isZero
I was given a certain module where in it performs a simple computation (the SUM function). What I’m tryin’ to do is add all the data from a specific fields and group by a certain field from another table. but the problem is the table containing the data to be calculated is three tables apart [...]
Filed under: SQL | 1 Comment
Tags: group by, performance tuning, SQL index
SQL Union All
I was working in this certain module last week wherein I will create a web app page that will generate monthly reports. Everything was fine and I manage to do it with an ease until the boss checks my work, On the report generated, there was a certain field column wherein NULL values are present, [...]
Filed under: SQL | Leave a Comment
Tags: SQL, Union
