Hi Butch Bean,
What if you use a temporary table .
Issue the following queries.
Create temporary table tmptable as select sent_id,count(*) cnt
from tbl_sent group by sent_id;
Select sum(if(sent_id < idvar,1,0)) as lessthan,
sum(if(sent_id >idvar,1,0)) as greaterthan
from tmptable;
Let us kn
I have a table with 2.9 mil records which represents 197k sentences stored
vertically. I do this because I need to know information about each word
and its relationship to other tables.
I want to know how many words have a particular word-group ID before and a
particular word-group ID after the
