Chip 2001 January/Chip_2001-01_cd1.bin/tema/mysql/mysql-3.23.28g-win.exe/DATA1.CAB/Examples/examples/tests/unique_users.tst

Text File | 2000-11-22 | 752b | 18 lines

# Parameter f÷r unique_users:
# uniq-fil, start_period, end_period, butiker ...

select unique_users("mmkonto_butik",1,12,"250600") from mm_system ;

select unique_users("mmkonto_butik",1,12,"250700","250600","250800") from mm_system ;

select unique_users("mmkonto_butik",1,24,"250700","250600","250800") from mm_system ;

select butik,unique_users("mmkonto_butik",1,1,butik) from butik where butik >= 250500 and butik <= 250800;

# Parameter f÷r group_unique_users:
# uniq-fil, start_period, end_period, butik

select butik,group_unique_users("mmkonto_butik",1,12,butik) from butik where butik >= 250500 and butik <= 250800 group by butik;

select group_unique_users("mmkonto_butik",1,12,butik) from butik where butik >= 250500 and butik <= 250800 ;