Run Code
|
API
|
Code Wall
|
Users
|
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
Please
log in
to post a comment.
CodificarArbolesDeDecisiónEstructuradaRobertoGutierrez
task5
inicio objeto examen
Astar
JPROBA
Arreglos_BautistaMoralesGabrielJovanni
List intro
isan
inicio del codificador de clasificador de objetos json con javascript
Tarea
Please log in to post a comment.