Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

13 views

SELECT COUNT(*) As SimilarPostCount FROM Posts P1, (SELEC...

jan 18
14 views

SELECT COUNT(*) FROM Posts P1, (SELECT Id, AnswerCount FR...

jan 18
14 views

SELECT COUNT(*) FROM Posts a, (SELECT Id, AnswerCount FRO...

jan 18
13 views

Select Answercount, count(*) as PostCount from posts grou...

jan 18
13 views

SELECT Answ.AnswersCount ,count(parentid) AS PostsCount F...

jan 18
13 views

Select Answercount, count(*) from posts group by answerco...

jan 18
13 views

SELECT Answ.AnswersCount ,count(parentid) AS PostsCount F...

jan 18
13 views

SELECT Answ.AnswersCount ,count(parentid) AS PostsCount F...

jan 18
13 views

SELECT Answ.AnswersCount ,count(parentid) AS PostsCount F...

jan 18
12 views

SELECT Sum(CAST(parentid AS BIGINT)) AS PostsCount FROM (...

jan 18
12 views

SELECT Sum(CAST(parentid AS BIGINT)) AS PostsCount FROM (...

jan 18
27 views

First characters of titles

jan 18 jlliagre
11 views

SELECT Answ.AnswersCount ,count(parentid) AS PostsCount F...

jan 18
11 views

select posttypeid, count (answercount) as Numberofanswers...

jan 18
11 views

select posttypeid, count (answercount) as Numberofanswers...

jan 18
11 views

SELECT Answ.AnswersCount ,count(parentid) AS PostsCount F...

jan 18
11 views

SELECT @@ROWCOUNT AS PostsCount FROM ( SELECT parentid,co...

jan 18
11 views

SELECT count(*) AS PostsCount FROM ( SELECT parentid,coun...

jan 18
12 views

SELECT Answ.AnswersCount ,count(parentid) AS PostsCount F...

jan 18
12 views

With PostCTE As (Select TOP 50 *, ROW_NUMBER()OVER(PARTIT...

jan 18
12 views

Select TOP 50 *, ROW_NUMBER()OVER(PARTITION BY parentid o...

jan 18
27 views

First characters of titles

jan 18 jlliagre
12 views

Select TOP 50 *, ROW_NUMBER()OVER(PARTITION BY parentid o...

jan 18
27 views

First characters of titles

jan 18 jlliagre
12 views

Select TOP 5 *, ROW_NUMBER()OVER(PARTITION BY parentid or...

jan 18
12 views

Select TOP 5 *, ROW_NUMBER()OVER(PARTITION BY parentid or...

jan 18
27 views

First characters of titles

jan 18 jlliagre
27 views

First characters of titles

jan 18 jlliagre
27 views

First characters of titles

jan 18 jlliagre
27 views

First characters of titles

jan 18 jlliagre
27 views

First characters of titles

jan 18 jlliagre
27 views

First characters of titles

jan 18 jlliagre
14 views

SELECT Answ.AnswersCount ,count(parentid) AS PostsCount F...

jan 18
14 views

select top 5 * from posts where AnswerCount >0

jan 18
14 views

select top 5 * from posts where AnswerCount <> null

jan 18
12 views

select top 5 * from posts

jan 18
12 views

select top 5 * from posts

jan 18
12 views

select top 5 * from posts

jan 18
12 views

select top 5 * from posts

jan 18
12 views

select top 5 * from posts

jan 18
12 views

select top 5 * from posts

jan 18
14 views

select top 5 * from posts

jan 18
14 views

select top 5 * from posts

jan 18
14 views

select top 5 * from posts

jan 18
14 views

select top 5 * from posts

jan 18
12 views

select top 5 * from posts

jan 18
12 views

select top 5 * from posts

jan 18
12 views

select top 5 * from posts

jan 18
12 views

select top 5 * from posts

jan 18
12 views

select top 5 * from posts

jan 18
12 views

select top 5 * from posts

jan 18
12 views

select top 5 * from posts

jan 18
12 views

select top 5 * from posts

jan 18
13 views

select top 5 * from posts

jan 18
13 views

select top 5 * from posts

jan 18
13 views

select top 5 * from posts

jan 18
13 views

select top 5 * from posts

jan 18
13 views

select top 5 * from posts

jan 18
14 views

select top 5 * from posts

jan 18
14 views

select top 5 * from posts

jan 18
13 views

select top 5 * from posts

jan 18
13 views

select top 5 * from posts

jan 18
13 views

select top 5 * from posts

jan 18
13 views

select top 5 * from posts

jan 18
12 views

select top 5 * from posts

jan 18
11 views

select top 5 * from posts

jan 18
12 views

select top 5 * from posts

jan 18
11 views

select top 5 * from posts

jan 18
11 views

select top 5 * from posts

jan 18
11 views

select top 5 * from posts

jan 18
11 views

select top 5 * from posts

jan 18
27 views

First characters of titles

jan 18 jlliagre
27 views

First characters of titles

jan 18 jlliagre
12 views

select Id from posts

jan 18
17 views

WITH Raw AS ( SELECT Votes.Id, Votes.CreationDate, LAG(Vo...

jan 18 peterh - PLEASE DELETE THIS ACCOUNT
10 views

SELECT Id, Score FROM Posts ORDER BY Score DESC;

jan 18
17 views

WITH Raw AS ( SELECT Id, CreationDate, LAG(CreationDate) ...

jan 18 peterh - PLEASE DELETE THIS ACCOUNT
10 views

SELECT DISTINCT PostId AS [Post Link] FROM PostHistory WH...

jan 18 peterh - PLEASE DELETE THIS ACCOUNT
10 views

SELECT PostId AS [Post Link] FROM PostHistory WHERE PostH...

jan 18 peterh - PLEASE DELETE THIS ACCOUNT
10 views

SELECT * FROM PostHistoryTypes;

jan 18 peterh - PLEASE DELETE THIS ACCOUNT
17 views

WITH Raw AS ( SELECT Id, CreationDate, LAG(Id) OVER (ORDE...

jan 18 peterh - PLEASE DELETE THIS ACCOUNT
17 views

WITH Raw AS ( SELECT Id, CreationDate, LAG(Id) OVER (ORDE...

jan 18 peterh - PLEASE DELETE THIS ACCOUNT
13 views

SELECT Id AS [Post Link], (SELECT MAX(v) FROM (VALUES (Cl...

jan 18
20 views

Hit and Run -- Version 2

jan 18
14 views

select userlist.uid, COUNT( distinct p.Id) as q_count, av...

jan 17
23 views

Tag Question/Answer counts.

jan 17 unknown35458
13 views

select userlist.uid, COUNT( distinct p.Id) as q_count, av...

jan 17
14 views

SELECT Id FROM Users WHERE DisplayName = 'SOCVR2Bot'

jan 17
14 views

SELECT Id FROM Users WHERE DisplayName = 'SOCVR2BOT'

jan 17
13 views

SELECT Id FROM Users WHERE DisplayName = 'SOCVR2BOT'

jan 17
13 views

select Userlist.uid as userid, count (distinct toptags.ta...

jan 17
13 views

select usertagexp.userid as userid, avg(usertagexp.tagexp...

jan 17
13 views

select usertagexp.userid as userid, avg(usertagexp.tagexp...

jan 17
13 views

select Userlist.uid as userid, count (distinct toptags.ta...

jan 17
13 views

select usertagexp.userid as userid, avg(usertagexp.tagexp...

jan 17
13 views

select UserList.uid as userid, count(distinct(pt.TagId)) ...

jan 17
13 views

select Userlist.uid as userid, count (distinct toptags.ta...

jan 17
13 views

select usertagexp.userid as userid, avg(usertagexp.tagexp...

jan 17
13 views

select usertagexp.userid as userid, avg(usertagexp.tagexp...

jan 17
14 views

select usertagexp.userid as userid, avg(usertagexp.tagexp...

jan 17
14 views

select UserList.uid as userid, count(distinct(pt.TagId)) ...

jan 17
14 views

select usertag.userid as userid, max(sumtag.tagbreadth) a...

jan 17
14 views

select usertag.userid as userid, max(sumtag.tagbreadth) a...

jan 17
23 views

Tag Question/Answer counts.

jan 17 unknown35458
14 views

select usertag.userid as userid, max(sumtag.tagbreadth) a...

jan 17
14 views

select usertag.userid as userid, count(distinct(usertag.t...

jan 17
23 views

Tag Question/Answer counts.

jan 17 unknown35458
14 views

select b.UserId as userid, b.Name as badge_name, count(b....

jan 17
13 views

select userlist.uid, COUNT( distinct p.Id) as bounty_q_co...

jan 17
13 views

select userlist.uid, COUNT( distinct p.Id) as bounty_q_co...

jan 17
13 views

select userlist.uid, COUNT( distinct p.Id) as bounty_q_co...

jan 17
13 views

select userlist.uid, COUNT( distinct p.Id) as bounty_q_co...

jan 17
12 views

select qcomplex.userId as userId, avg(qcomplex.maxfrequen...

jan 17
12 views

select qcomplex.userId as userId, avg(qcomplex.maxfrequen...

jan 17
12 views

select qcomplex.userId as userId, avg(qcomplex.maxfrequen...

jan 17
12 views

select qeasy.userId as userId, avg(qeasy.sum_easy) as sum...

jan 17
12 views

select qeasy.userId as userId, avg(qeasy.sum_easy) as sum...

jan 17
12 views

select qeasy.userId as userId, avg(qeasy.sum_easy) as sum...

jan 17
13 views

select p.OwnerUserId, min(cast(t.Count as numeric)) as mi...

jan 17
13 views

select p.OwnerUserId, min(cast(t.Count as numeric)) as mi...

jan 17
13 views

select p.OwnerUserId, min(cast(t.Count as numeric)) as mi...

jan 17
13 views

select b.UserId, avg(badgercomplexity.freq) as avg_tag_ba...

jan 17
13 views

select b.UserId, count(b.Id) as badge_count from Badges b,

jan 17
13 views

select userlist.uid, COUNT(v.Id) as fav_count, datediff(m...

jan 17
13 views

select userlist.uid, COUNT(se.Id) as se_count, datediff(m...

jan 17
13 views

select userlist.uid, COUNT(c.Id) as comment_count, avg(c....

jan 17
13 views

select qlist.uid as userId, count(ph.Id) as edit_counttot...

jan 17
13 views

select qlist.uid as userId, count(ph.Id) as edit_counttot...

jan 17
13 views

select qlist.uid as userId, count(ph.Id) as edit_counttot...

jan 17
13 views

select qlist.uid as userId, count(p.Id) as answer_count,A...

jan 17
13 views

select qlist.uid as userId, count(p.Id) as answer_count,A...

jan 17
13 views

select qlist.uid as userId, count(p.Id) as answer_count,A...

jan 17
13 views

select userlist.uid, COUNT( distinct p.Id) as q_count, av...

jan 17
13 views

select userlist.uid, COUNT( distinct p.Id) as q_count, av...

jan 17
12 views

select userlist.uid, COUNT( distinct p.Id) as q_count, av...

jan 17
12 views

select qcomplex.userId as userId, sum(qcomplex.complexity...

jan 17

30 50 100 per page

1,653,743

queries

Q&A for linguists, teachers and learners wanting to discuss the finer points of the Portuguese language

2.1k questions

3.6k answers

15k comments

164 tags

jan 17 most recent