| USE fawiki_p;
SELECT user_name, COUNT(*)
FROM revision JOIN page ON... |
7 years ago |
| USE fawiki_p;
SELECT row_number() over (order by count(*) desc) as rank,... |
7 years ago |
| USE fawiki_p;
SELECT rank=count(*), user_name, COUNT(*)
FROM revision JOIN... |
7 years ago |
| USE fawiki_p;
SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*)), user_name,... |
7 years ago |
| USE fawiki_p;
SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC), user_name,... |
7 years ago |
| USE fawiki_p;
SELECT user_name, COUNT(*)
FROM revision JOIN page ON... |
7 years ago |
| USE fawiki_p;
SELECT user_name, COUNT(*)
FROM revision JOIN page ON... |
7 years ago |
| USE fawiki_p;
SELECT user_name, COUNT(*)
FROM revision JOIN page ON... |
7 years ago |
| USE fawiki_p;
SELECT DISTINCT rev_timestamp,user_name
FROM revision join... |
7 years ago |
| USE fawiki_p;
SELECT DISTINCT rev_timestamp,user_name
FROM revision join... |
7 years ago |
