1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
create table visite
(
vis_id int identity(1, 1) not null primary key,
cli_id int not null references client(cli_id),
vis_date datetime not null default getdate(),
vis_hour as datepart(hour, vis_date)
);
create index vis_idx_hour on visite(vis_hour);
insert into visite (vis_date, cli_id) values ('2012-08-29 15:10:00', 1);
insert into visite (vis_date, cli_id) values ('2012-08-29 15:20:00', 1);
insert into visite (vis_date, cli_id) values ('2012-08-29 15:10:00', 2);
insert into visite (vis_date, cli_id) values ('2012-08-29 16:10:00', 2);
select vis_hour, COUNT(*)
from visite
group by vis_hour;
select *
from visite
where vis_hour = 15; |
Partager