SuperQuery, Prolog

SuperQuery

Language: Layout:

[ - ] Show input
Absolute running time: 0.43 sec, cpu time: 0.3 sec, memory peak: 7 Mb, absolute service time: 0,55 sec

edit mode | history | discussion

select nombretabla1, count()/(select count() from arbol ) as probabilidad from arbol where nombretabla1 in(select distinct nombretabla1 from arbol )  group by nombretabla1 ;  

select nombretabla1, nombretabla2, count()/(select count() from arbol ) as Probabilidad from arbol where nombretabla1 in(select distinct nombretabla1 from arbol )  and nombretabla2 in(select distinct nombretabla2 from arbol) group by nombretabla2, nombretabla1 order by nombretabla1, nombretabla2;
true.

λ

                                      .NET NoSQL database for rapid development