USE enwiki_p;
SELECT page_title,
Sum(rev_cnt) / Count(DISTINCT... |
5 years ago |
USE enwiki_p;
SELECT page_title,
Sum(rev_cnt) / Count(DISTINCT... |
5 years ago |
USE enwiki_p;
SELECT page_title,
Sum(rev_cnt) / Count(DISTINCT... |
5 years ago |
USE enwiki_p;
SELECT page_title,
Sum(rev_cnt) / Count(DISTINCT... |
5 years ago |
USE enwiki_p;
SELECT page_title,
Sum(rev_cnt) / Count(DISTINCT... |
5 years ago |
USE enwiki_p;
#SELECT page_title,
# Sum(rev_cnt) / Count(DISTINCT... |
5 years ago |
USE enwiki_p;
SELECT page_title,
Sum(rev_cnt) / Count(DISTINCT... |
5 years ago |
USE enwiki_p;
SELECT page_title,
Sum(rev_cnt) / Count(DISTINCT... |
5 years ago |
USE enwiki_p;
SELECT page_title,
Sum(rev_cnt) / Count(DISTINCT... |
5 years ago |
USE enwiki_p;
SELECT page_title,
Sum(rev_cnt) / Count(DISTINCT... |
5 years ago |
USE enwiki_p;
SELECT page_title,
Sum(rev_cnt) / Count(DISTINCT... |
5 years ago |
USE enwiki_p;
SELECT page_title,
Sum(rev_cnt) / Count(DISTINCT... |
5 years ago |
USE enwiki_p;
SELECT page_title,
Sum(rev_cnt) / Count(DISTINCT... |
5 years ago |
USE enwiki_p;
SELECT page_title,
Sum(rev_cnt) / Count(DISTINCT... |
5 years ago |
USE enwiki_p;
SELECT page_title,
Sum(rev_cnt) / Count(DISTINCT... |
5 years ago |
USE enwiki_p;
SELECT page_title,
Sum(rev_cnt) / Count(DISTINCT... |
5 years ago |
USE enwiki_p;
SELECT page_title,
Sum(rev_cnt) / Count(DISTINCT... |
5 years ago |
USE enwiki_p;
SELECT page_title,
Sum(rev_cnt) / Count(DISTINCT... |
5 years ago |
USE enwiki_p;
SELECT page_title,
Sum(rev_cnt) / Count(DISTINCT... |
5 years ago |
USE enwiki_p;
SELECT page_title,
Sum(rev_cnt) / Count(DISTINCT... |
5 years ago |
USE enwiki_p;
SELECT page_title,
Sum(rev_cnt) / Count(DISTINCT... |
5 years ago |
USE enwiki_p;
SELECT page_title,
Sum(rev_cnt) / Count(DISTINCT... |
5 years ago |
USE enwiki_p;
select page_title,
sum(rev_cnt)/count(distinct rev_user) as... |
5 years ago |
USE enwiki_p;
select page_title,
sum(rev_cnt)/count(distinct rev_user) as... |
5 years ago |
USE enwiki_p;
select page_title,
sum(rev_cnt)/count(distinct rev_user) as... |
5 years ago |
USE enwiki_p;
select count(distinct rev_user) from revision
join page
on... |
5 years ago |
USE enwiki_p;
select page_title, sum(rev_cnt)/count(distinct rev_user) as... |
5 years ago |
USE enwiki_p;
select page_title, sum(rev_cnt)/count(distinct rev_user) as... |
5 years ago |
USE enwiki_p;
select page_title, sum(rev_cnt)/count(distinct rev_user) as... |
5 years ago |
USE enwiki_p;
select page_title, sum(rev_cnt)/count(distinct rev_user) as... |
5 years ago |
USE enwiki_p;
select page_title, sum(rev_cnt)/count(distinct rev_user),... |
5 years ago |
USE enwiki_p;
select page_title, sum(rev_cnt)/count(distinct rev_user),... |
5 years ago |
USE enwiki_p;
select count(distinct rev_id) as rev_cnt,
page_title,
... |
5 years ago |
USE enwiki_p;
select page_title, sum(rev_cnt)/count(distinct rev_user),... |
5 years ago |
USE enwiki_p;
select page_title, sum(rev_cnt)/count(distinct rev_user)
from... |
5 years ago |
USE enwiki_p;
select * from
(select page_id, page_namespace, page_title... |
5 years ago |
USE enwiki_p;
select * from
(select page_id, page_namespace, page_title... |
5 years ago |
USE enwiki_p;
WITH ct as (select page_id, page_namespace, page_title from... |
5 years ago |
with ct as (
select page_id, page_namespace, page_title
from page
... |
5 years ago |
with ct as (
select page_id, page_namespace, page_title
from page
... |
5 years ago |
with ct as (
select page_id, page_namespace, page_title
from page
... |
5 years ago |
with ct as (
select page_id, page_namespace, page_title
from page
... |
5 years ago |
with ct as (
select page_id, page_namespace, page_title
from page
... |
5 years ago |
USE enwiki_p;
with ct as (
select page_id, page_namespace, page_title
... |
5 years ago |
USE enwiki_p;
select page_id, page_namespace, page_title
from page
... |
5 years ago |
USE enwiki_p;
with recursive t as (
select count(distinct rev_id) as... |
5 years ago |
USE enwiki_p;
with recursive t as (
select count(distinct rev_id) as... |
5 years ago |
USE enwiki_p;
with recursive t as (
select count(distinct rev_id) as... |
5 years ago |
USE enwiki_p;
with t as (
select count(distinct rev_id) as rev_cnt,... |
5 years ago |
USE enwiki_p;
with t as (
select count(distinct rev_id) as rev_cnt,... |
5 years ago |
USE enwiki_p;
with t as (
select count(distinct rev_id) as rev_cnt,... |
5 years ago |
USE enwiki_p;
select count(distinct rev_id) as rev_cnt,
page_title,
... |
5 years ago |
USE enwiki_p;
with t as (
select count(distinct rev_id) as rev_cnt,... |
5 years ago |
USE enwiki_p;
with t as (
select count(distinct rev_id) as rev_cnt,... |
5 years ago |
USE enwiki_p;
with t as (
select count(distinct rev_id) as rev_cnt,... |
5 years ago |
USE enwiki_p;
with t as (
select count(distinct rev_id) as rev_cnt,... |
5 years ago |
USE enwiki_p;
with t as (
select count(distinct rev_id) as rev_cnt,... |
5 years ago |
USE enwiki_p;
with t as (
select count(distinct rev_id) as rev_cnt,... |
5 years ago |
USE enwiki_p;
with t as (
select count(distinct rev_id) as rev_cnt,... |
5 years ago |
USE enwiki_p;
with cte_x as (
select count(distinct rev_id) as rev_cnt,... |
5 years ago |
USE enwiki_p;
with cte_x as (
select count(distinct rev_id) as rev_cnt,... |
5 years ago |
USE enwiki_p;
with cte_x as (
select count(distinct rev_id) as rev_cnt,... |
5 years ago |
USE enwiki_p;
select count(distinct rev_id) as rev_cnt,
page_title,
... |
5 years ago |
USE enwiki_p;
select count(distinct rev_id) as rev_cnt,
rev_page,
... |
5 years ago |
USE enwiki_p;
select count(distinct rev_id) as rev_cnt,
rev_page,
... |
5 years ago |
USE enwiki_p;
select count(distinct rev_id) as rev_cnt,
rev_page,
... |
5 years ago |
USE enwiki_p;
select count(distinct rev_id) as rev_cnt,
rev_page,
... |
5 years ago |
USE enwiki_p;
select count(distinct rev_id) as rev_cnt,
rev_page,
... |
5 years ago |
USE enwiki_p;
select count(distinct rev_id) as rev_cnt,
rev_page,
... |
5 years ago |
USE enwiki_p;
select count(distinct rev_id)
over(partition by... |
5 years ago |
USE enwiki_p;
select count(distinct rev_id)
over(partition by... |
5 years ago |
USE enwiki_p;
select count(distinct rev_id)
over(partition by... |
5 years ago |
USE enwiki_p;
select count(distinct rev_id) over(partition by... |
5 years ago |
USE enwiki_p;
select count(distinct rev_id) as rev_cnt, rev_page,... |
5 years ago |
USE enwiki_p;
select count(distinct rev_id) as rev_cnt, rev_page,... |
5 years ago |
USE enwiki_p;
select count(distinct rev_id), rev_page, rev_minor_edit from... |
5 years ago |
USE enwiki_p;
select count(distinct rev_id), rev_page, rev_minor_edit from... |
5 years ago |
USE enwiki_p;
select count(distinct rev_id), rev_page from revision
where... |
5 years ago |
USE enwiki_p;
select max(rev_timestamp), rev_page from revision
where... |
5 years ago |
USE enwiki_p;
select max(rev_timestamp), rev_page from revision
where... |
5 years ago |
USE enwiki_p;
select max(rev_timestamp) from revision
where rev_page... |
5 years ago |
USE enwiki_p;
select * from page
where page_title in ('Sugar','Salt'); |
5 years ago |
USE enwiki_p;
select count(distinct rev_user) from revision
where rev_page... |
5 years ago |
USE enwiki_p;
select count(distinct rev_user), rev_page, rev_minor_edit from... |
5 years ago |
USE enwiki_p;
select count(distinct rev_user), rev_page, rev_minor_edit from... |
5 years ago |
USE enwiki_p;
select count(distinct rev_user), rev_page, rev_minor_edit from... |
5 years ago |
USE enwiki_p;
select * from revision
where rev_page in
(select page_id from... |
5 years ago |
USE enwiki_p;
select count(*), rev_page, rev_minor_edit from revision
where... |
5 years ago |
USE enwiki_p;
select count(*), rev_minor_edit from revision
where rev_page... |
5 years ago |
USE enwiki_p;
select * from revision
where rev_page in
(select page_id from... |
5 years ago |
USE enwiki_p;
select * from revision
where rev_page in
(select page_id from... |
5 years ago |
USE enwiki_p;
select page_id from page
where page_title in... |
5 years ago |
USE enwiki_p;
select page_id, page_namespace, page_title from page
where... |
5 years ago |
USE enwiki_p;
select page_id, page_namespace, page_title from page
where... |
5 years ago |
USE enwiki_p;
select * from page
where page_title in ('Sugar','Salt')
and... |
5 years ago |
USE enwiki_p;
select * from page
where page_title in ('Sugar','Salt'); |
5 years ago |
//USE enwiki_p;
select * from page
where page_title in ('Sugar','Salt'); |
5 years ago |
//USE enwiki_p;
select top 100 * from page; |
5 years ago |
USE enwiki_p; |
5 years ago |