Re: [sqlite] Most Frequent Occurrence Problem

I had been trying to learn proper use of the coalesce function via experimenting. After many tries I found that the coalesce function only was working for me with one set of brackets, I think I must have been causing a conflict due to the context of the function. If I introduced more than one

Re: [sqlite] Most Frequent Occurrence Problem

On Fri, 2 Dec 2011 21:10:54 -0800 (PST), Macgyver7 wrote: > > I am not sure exactly how I am to work in the coalesce function to get the > result, I tried some experiments and I could get the first and or second > fields in another column, but not as part of the

Re: [sqlite] Most Frequent Occurrence Problem

I am not sure exactly how I am to work in the coalesce function to get the result, I tried some experiments and I could get the first and or second fields in another column, but not as part of the bracketed group. This is the argument as it stands now, (without the coalesce function) how should

Re: [sqlite] Most Frequent Occurrence Problem

Macgyver7 wrote: > Thanks Igor, that works, however there is a problem. This will only return a > result when there are no null fields in the last two columns. The first > column has results in every field, but columns 2 and 3 don't have results in > every field. How

Re: [sqlite] Most Frequent Occurrence Problem

Thanks Igor, that works, however there is a problem. This will only return a result when there are no null fields in the last two columns. The first column has results in every field, but columns 2 and 3 don't have results in every field. How do I get around this not returning anything when

Re: [sqlite] Most Frequent Occurrence Problem

Macgyver7 wrote: > Many thanks Igor, that worked beautifully. If I wanted to put the three top > meanings in one column separated by commas, instead of three columns, is > there an easy way to do that? It would be good to have them in brackets too. > eg. (meaning 1,

Re: [sqlite] Most Frequent Occurrence Problem

ent: Friday, December 02, 2011 4:04 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Most Frequent Occurrence Problem Many thanks Igor, that worked beautifully. If I wanted to put the three top meanings in one column separated by commas, instead of three columns, is there an easy way to do

Re: [sqlite] Most Frequent Occurrence Problem

Many thanks Igor, that worked beautifully. If I wanted to put the three top meanings in one column separated by commas, instead of three columns, is there an easy way to do that? It would be good to have them in brackets too. eg. (meaning 1, meaning 2, meaning 3) Thanks for the help, Tim.

Re: [sqlite] Most Frequent Occurrence Problem

Macgyver7 wrote: > I have a table with three columns, Col1, Col2 and Meaning. I have multiple > occurrences of distinct words within the column, Col2, with it's specific > meaning for each word listed in the Meaning column. There are multiple > occurrences of each

[sqlite] Most Frequent Occurrence Problem

I have a table with three columns, Col1, Col2 and Meaning. I have multiple occurrences of distinct words within the column, Col2, with it's specific meaning for each word listed in the Meaning column. There are multiple occurrences of each distinct word and meaning combination. How do I return