MySQL Functions Questions and Answers

Recent IT Questions

1 - 2 of 2
<<PREVIOUS 1 NEXT>>

Count/Sum Question

Hi I have a field with only 2 values. 0 and -1. I am interested in counting the -1's that occur only if they occur 4 or more times consecutively. Therefore, if the output were 0, 0, -1, -1, 0 the output would be 0. However, if it were 0,0,-1,-1,-1,-1,-1, 0, 0, -1,-1,-1,-1 the sum would be 9. Help...

View Answer   |  Sep 22 2009  7:52 PM GMT
COUNTIF statement, SQL commands, MySQL functions
asked by Chhmusic

  15 pts.

how to return entire table records using mysql database functions

how to return entire table records using mysql database functions

View Answer   |  May 25 2009  5:14 AM GMT
MySQL functions
asked by Danyind

  5 pts.

1 - 2 of 2
<<PREVIOUS 1 NEXT>>