| SELECT
YEAR(STR_TO_DATE(rev_timestamp, '%Y%m%d%H%i%s')) AS year,
... |
3 months ago |
| select extract(MONTH FROM r.rev_timestamp),count(u.user_id)
FROM revision... |
3 months ago |
| select count(u.user_id)
FROM revision r
JOIN actor a ON r.rev_actor =... |
3 months ago |
| select extract(MONTH from r.rev_timestamp),count(r.rev_id)
FROM revision... |
3 months ago |
| select month(r.rev_timestamp),count(r.rev_id)
FROM revision r
JOIN actor a... |
3 months ago |
| select month(r.rev_timestamp),count(r.rev_id)
FROM revision r
JOIN actor a... |
3 months ago |
| SELECT MONTH(r.rev_timestamp) AS month, COUNT(DISTINCT u.user_id) AS... |
3 months ago |
| SELECT MONTH(r.rev_timestamp) AS month, COUNT(u.user_id) AS... |
3 months ago |
| SELECT MONTH(r.rev_timestamp) AS month, COUNT(u.user_id) AS... |
3 months ago |
| SELECT MONTH(r.rev_timestamp) AS month, COUNT(u.user_id) AS... |
3 months ago |
| SELECT MONTH(r.rev_timestamp) AS month, COUNT(u.user_id) AS... |
3 months ago |
| SELECT MONTH(r.rev_timestamp) AS month, COUNT(DISTINCT u.user_id) AS... |
3 months ago |
| select rev_user from revision
limit 10;
|
3 months ago |
| SELECT
EXTRACT(YEAR_MONTH FROM rev_timestamp) AS year_month,
... |
3 months ago |
| select count(*) from user
group by user_id; |
3 months ago |
| select count(*) from user; |
3 months ago |
| select to_char(rev_timestamp,'Month'),count(*) from revision
where... |
3 months ago |
| select to_char(rev_timestamp,'Month'),count(*) from revision
where... |
3 months ago |
| select to_char(rev_timestamp,'Month'),count(*) from revision
where... |
3 months ago |
| select to_char(rev_timestamp,'MONTH') from revision
limit 50; |
3 months ago |
| select to_char(rev_timestamp,'MONTH') from revision
limit 10; |
3 months ago |
| select extract(month from rev_timestamp) from revision; |
3 months ago |
| select extract(month from rev_timestamp) from revision
limit 20; |
3 months ago |
| select extract(month from rev_timestamp) from revision
limit 10; |
3 months ago |
| select extract(year from rev_timestamp) from revision
limit 10; |
3 months ago |
| select extract(year from rev_timestamp) from revision; |
3 months ago |
| select user_id,user_name,user_editcount
from user
order by user_editcount... |
3 months ago |
| select user_id,user_name,user_editcount
from user
order by user_editcount... |
3 months ago |
| select user_id,user_name,user_editcount
from user
order by user_editcount desc; |
3 months ago |
| select count(*) from user
where extract(year from user_registration) = '2024'
; |
3 months ago |
| select extract(year from user_registration) from user
limit 2; |
3 months ago |
| select * from user
limit 2; |
3 months ago |
