sqlite

[jashimu]

Hi All, I am trying to do some query in my sqlite database. I wanted to get average of some number, but could not do it. if you please can, write a sql statement that get average of some number. "SELECT AVE(w)FROM x WHERE y = z "; It should return the ave of all w. thanks in advance

[dxlee]

AVE is wrong. You should use AVG.

[jashimu]

Hi dxlee, it is really a silly mistake. I meant to do avg not ave and I could not figure it out what was wrong. thanks a lot.

[dxlee]

I am glad I could help. I like sqlite. My electronic document manager uses sqlite and it is much faster than my previous version (which used Microsoft Access).