7 Haziran 2009 Pazar

QLIBX, DRILL komutu, Pivot işlemleri

;BROWSE=sample output

select top 1000 FIRMA, MARKA, GRAMAJ, BOLGE [~PAGE~BOLGE], KANAL [~VERT~KANAL], PERIOD [~VERT~PERIOD], PEN [~FACT~PEN]
from TEMPSUTAS


;DRILL=sample output

select FIRMA, MARKA, GRAMAJ, BOLGE [~PAGE~BOLGE], KANAL [~VERT~KANAL], PERIOD [~VERT~PERIOD], PEN [~FACT~PEN]--, TYP
from TEMPSUTAS
order by FIRMA, MARKA, GRAMAJ, BOLGE, KANAL, PERIOD


;

Hiç yorum yok: