askhsh sql mporeite na boithisete help einai sos

[hkyriakos]

an mporeite na me boithisete me aythn thn exw gia ergasia se sxolh alla den mporesa na brw lysh:esw oti exoume mia naytiliakh etairia pou diathrei ton pinaka ths morfis

kodiko mhnas hmera kenes theseis

123 4 23 0

234 4 29 2

567 5 3 10

opou h proti sthlh periexei tous kodikous ton dromologion h deyterh to mhna poy tha ektelestei h trith thn hmera kai h tetarth to plhthos ton kenon theseon .na ftiaxete mia synartish pou na ypologizei kai na epistrefei posa dromologia pou exoun kenes theseis ektelountai mia sygkekrimenh hmeomhnia.H synastish tha dexete san orismata ton pinaka dromologia katallhlo plithos orismaton gia to megethos tou enan akeraio gia ton mhna enan akeraio gia th mera gia thn opoia theloume na broume ta dromologia epishs na ftiaxete programma pou na elexei thn orthotita ths synartishs an mporeite na me boithisete tha einai megali mou xara

[Sta]

Κάπως έτσι:

>
SELECT COUNT(*) FROM dromologia WHERE kenes_theseis>0 AND (mhnas=6 AND hmera=19); 

και το διαμορφώνεις κατάλληλα για τις ανάγκες σου.

[hkyriakos]

ok tha to dokimaso ka tha sou po pantos thanks gia thn boitheia