| USE simplewiki_p;
SELECT top 1 percent * from user order by newid()
#SELECT... |
7 years ago |
| USE simplewiki_p;
SELECT user_id from user TABLESAMPLE(1 percent);
#SELECT... |
7 years ago |
| USE simplewiki_p;
DECLARE @mylist(user_id FROM user LIMIT 10);
#SELECT... |
7 years ago |
| USE simplewiki_p;
DECLARE @mylist(SELECT user_id FROM user LIMIT... |
7 years ago |
| USE simplewiki_p;
DECLARE @mylist(SELECT user_id FROM user LIMIT... |
7 years ago |
| USE simplewiki_p;
DECLARE @mylist(SELECT user_id FROM user LIMIT 10);... |
7 years ago |
| USE simplewiki_p;
CREATE TABLE mylist(user_id FROM user LIMIT 10);
#SELECT... |
7 years ago |
| USE simplewiki_p;
CREATE TABLE mylist(SELECT user_id FROM user LIMIT 10);... |
7 years ago |
| USE simplewiki_p;
CREATE TABLE mylist(SELECT rev_user FROM revision LIMIT... |
7 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts, rev_user, user_name,... |
7 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts, rev_user, user_name,... |
7 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts, rev_user, user_name,... |
7 years ago |
| USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts, rev_user, user_name,... |
7 years ago |
