Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
SuperQueries
%Leemos la tabla, campo1 y campo2y se llaman las funciones que generan los query superquery:- read(T), read(C), read(C2), superquery1(T,C), superquery2(T,C,C2). %Sentencia para generar query 1 superquery1(T,C):- write('select '), write(C), write(', '), sentenciacount(T), write(') as probabilidad from '), write(T), write(' where '), sentenciain(T,C), write(' group by '),write(C), write(';\n'). %El \n solo es para presentación en consola %Sentencia para generar query 2 superquery2(T,C,C2):- write('select '), write(C), write(', '), write(C2), write(', '),sentenciacount(T), write(') as Probabilidad from '), write(T), write(' where '), sentenciain(T,C), write(' AND '), sentenciain(T,C2), write(' group by '), write(C2), write(','), write(C), write(' order by '), write(C), write(', '), write(C2), write(';'). %Sentencias que se repiten en ambos query, simplificando para escribir menos sentenciacount(T):- write('count(*)/(select count(*) from '), write(T). sentenciain(T,C):- write(C), write( ' in(select distinct '),write(C), write(' from '), write(T),write(')'). :- superquery.
run
|
edit
|
history
|
help
0
gramática loco 4 marzo
Superquerys_Segura_Sanchez
json con metodos
tarea arreglos
BD_2
Sánchez López Fernando Gabriel - JSON arrays
JPROBA
Martinez Lopez Said - CICLO FOR Completo
Méndez Huerta Janet- Empresa 38
Arreglos_Huerta-Chavarria-Christopher-Paul