Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

Generador Query

Language: Layout:
- ] Show input
Absolute running time: 0.47 sec, cpu time: 0.26 sec, memory peak: 7 Mb, absolute service time: 0,66 sec 
edit mode |  history  | discussion
select tabla1, count()/(select count() from financieras) as probabilidad from financieras where tabla1 in(select distinct tabla1 from financieras) group by tabla1;
select tabla1, tabla2, count()/(select count() from financieras) as Probabilidad from financieras where tabla1 in(select distinct tabla1 from financieras) and tabla2 in(select distinct tabla2 from financieras) group by tabla1, tabla1 order by tabla1, tabla2;

    
                
λ
.NET NoSQL database for rapid development