I would like to perform a count query based on row..
In normal query we can use (to count column)But now I want to count the occurrences in a row...Code:SELECT COUNT(*) FROM .....
For Example:
ID NAME JUNE JULY AUG SEP COUNT 1 PETER N 3 2 HENRY N N
N 1 3 DEVID N
3 4 KEVIN
0
In the above table I want to update the COUNT Column with the blank count row-wise....
Hope I can get answer here...