1 |
select ip,count(ip) from log group by ip; |
select |
2 |
|
count(ip), |
3 |
|
ip |
4 |
|
from log |
5 |
|
group by ip |
6 |
|
order by count(ip) desc |
7 |
|
limit 10 |
8 |
|
; |
9 |
|
|
10 |
select * from log order by id desc limit 20 ; |
select |
11 |
|
count(program), |
12 |
|
program |
13 |
|
from log |
14 |
|
group by program |
15 |
|
order by count(program) desc |
16 |
|
limit 10 |
17 |
|
; |
18 |
|
|
19 |
|
select |
20 |
|
count(facility), |
21 |
|
facilities.name |
22 |
|
from log |
23 |
|
full join facilities on facilities.id = log.facility |
24 |
|
group by program,facilities.name |
25 |
|
order by count(facility) desc |
26 |
|
limit 10 |
27 |
|
; |
28 |
|
|
29 |
|
select * from log order by id desc limit 5 ; |