Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

3 views

WITH RecentPosts AS ( SELECT p.OwnerUserId, COUNT(*) AS P...

dec 2 jon.doe45850
3 views

WITH RecentPosts AS ( SELECT p.OwnerUserId, COUNT(*) AS P...

dec 2 jon.doe45850
18 views

WITH UserAggregates AS ( SELECT Users.Id AS UserId, Users...

dec 2 jon.doe45916
18 views

SELECT Users.Id, DisplayName FROM Users WHERE Users.Id IN...

dec 2 jon.doe45916
31 views

WITH UserAggregates AS ( SELECT Users.Id AS UserId, COUNT...

dec 2 jon.doe46441
31 views

WITH UserAggregates AS ( SELECT Users.Id AS UserId, COUNT...

dec 2 jon.doe46441
31 views

WITH UserAggregates AS ( SELECT Users.Id AS UserId, COUNT...

dec 2 jon.doe46441
28 views

WITH UserStats AS ( SELECT Users.Id AS UserId, COUNT(Post...

dec 2 jon.doe45916
28 views

WITH UserStats AS ( SELECT Users.Id AS UserId, COUNT(Post...

dec 2 jon.doe45916
10 views

WITH UserStats AS ( SELECT Users.Id AS UserId, COUNT(Post...

dec 2
10 views

WITH UserStats AS ( SELECT Users.Id AS UserId, COUNT(Post...

dec 2
10 views

WITH UserStats AS ( SELECT Users.Id AS UserId, COUNT(Post...

dec 2
28 views

WITH UserAggregates AS ( SELECT Users.Id AS UserId, SUM(C...

dec 2 jon.doe45916
10 views

WITH UserStats AS ( SELECT Users.Id AS UserId, COUNT(Post...

dec 2
12 views

SELECT TOP 500 Id AS UserId, Reputation, DATEDIFF(DAY, Cr...

dec 2
12 views

SELECT TOP 200 Id, Reputation, DATEDIFF(DAY, CreationDate...

dec 2
73 views

How to get

dec 2 MdoubleDash
73 views

How to get

dec 2 MdoubleDash
73 views

How to get

dec 2 MdoubleDash
13 views

SELECT TOP 1000 u.id AS UserId, u.Reputation, u.CreationD...

dec 2
28 views

SELECT TOP 1000 u.id AS UserId, u.Reputation, u.CreationD...

dec 2
14 views

SELECT TOP 1000 u.id AS UserId, u.Reputation, u.CreationD...

dec 2
28 views

SELECT TOP 1000 u.id AS UserId, u.Reputation, u.CreationD...

dec 2
14 views

SELECT TOP 1000 u.Id, u.Reputation, u.CreationDate, u.Las...

dec 2 jon.doe45883
14 views

SELECT TOP 1000 * FROM Users ORDER BY RAND()

dec 2
15 views

SELECT TOP 500 P.OwnerUserId AS UserId, COUNT(P.Id) AS To...

dec 2
28 views

SELECT TOP 1000 u.Id, u.Reputation, u.CreationDate, u.Las...

dec 2
28 views

SELECT TOP 1000 u.Id, u.Reputation, u.CreationDate, u.Las...

dec 2
14 views

SELECT TOP 1000 u.Id, u.Reputation, u.CreationDate, u.Dis...

dec 2
28 views

SELECT TOP 1000 u.Id, u.Reputation, u.CreationDate, u.Dis...

dec 2
28 views

SELECT TOP 1000 u.Id, u.Reputation, u.CreationDate, u.Dis...

dec 2
15 views

SELECT TOP 500 P.OwnerUserId AS UserId, COUNT(P.Id) AS To...

dec 2
16 views

SELECT TOP 500 P.OwnerUserId AS UserId, COUNT(P.Id) AS To...

dec 2
15 views

SELECT TOP 500 P.OwnerUserId AS UserId, COUNT(P.Id) AS To...

dec 2
15 views

SELECT TOP 500 Id AS UserId, Reputation, UpVotes, DownVot...

dec 2
14 views

SELECT (SELECT count(id) FROM Posts) AS CountPosts, (SELE...

dec 2
28 views

Posts

dec 2
14 views

select count(id) from users where reputation>100

dec 2
73 views

How to get

dec 2 MdoubleDash
14 views

SELECT U.Id AS UserId, DATEDIFF(DAY, U.CreationDate, GETD...

dec 2
25 views

SELECT DISTINCT DisplayName FROM Users WHERE Location='Лу...

dec 2
13 views

SELECT TOP 1000 u.id AS UserId, u.Reputation, u.CreationD...

dec 2
27 views

SELECT TOP 10 DisplayName, COUNT(Posts.Id) AS Count_Posts...

dec 2
14 views

SELECT TOP 10 DisplayName, COUNT(Posts.Id) AS Count_Posts...

dec 2
27 views

SELECT TOP 10 DisplayName, COUNT(Posts.Id) AS Count_Posts...

dec 2
25 views

SELECT TOP 10 DisplayName, COUNT(Posts.Id) AS Count_Posts...

dec 2
116 views

SELECT id FROM posts where owneruserid = 9945429

dec 2 jon.doe46342
116 views

SELECT id FROM posts where owneruserid = 23915049

dec 2 jon.doe46342
116 views

SELECT id FROM posts where owneruserid = 17739617

dec 2 jon.doe46342
116 views

SELECT * FROM posts where owneruserid = 17739617

dec 2 jon.doe46342
116 views

Select * from posts where owneruserid = '17739617'

dec 2 jon.doe46342
116 views

SELECT TOP 300 * FROM users ORDER BY NEWID()

dec 2 jon.doe46342
116 views

SELECT TOP 100 * FROM users ORDER BY NEWID()

dec 2 jon.doe46342
116 views

SELECT TOP 5 * FROM users ORDER BY NEWID()

dec 2 jon.doe46342
116 views

SELECT TOP 5 Id FROM users ORDER BY NEWID()

dec 2 jon.doe46342
92 views

select * from users where rand() < (1 / (select count(300...

dec 2 jon.doe46342
92 views

select * from users where rand() < (300 / (select count(3...

dec 2 jon.doe46342
92 views

SELECT TOP 300 * FROM users

dec 2 jon.doe46342
92 views

select rand(300) creationdate from users where creationd...

dec 2 jon.doe46342
92 views

select creationdate from users where creationdate > '2024...

dec 2 jon.doe46342
92 views

select creationdate from users

dec 2 jon.doe46342
92 views

select id from posts

dec 2 jon.doe46342
14 views

Select * from users Order by rand()

dec 2
28 views

SELECT Id, Title, ViewCount FROM dbo.Posts P WHERE P.Id =...

dec 2 Larnu
28 views

SELECT * FROM dbo.Posts P WHERE P.Id = ##PostId:int##

dec 2 Larnu
56 views

SELECT TOP 200 * FROM Comments ORDER BY Score ASC, Text A...

dec 2 Pet237d160.The160.Spring160.Wizard
56 views

SELECT TOP 200 * FROM Comments ORDER BY Score DESC, Text ...

dec 2 Pet237d160.The160.Spring160.Wizard
26 views

select COUNT(*) from Posts;

dec 2
28 views

select COUNT(id) from Users;

dec 2
15 views

select COUNT(*) from Users;

dec 2
28 views

select COUNT(*) from Users;

dec 2
26 views

select COUNT(*) from Users;

dec 2
16 views

CREATE table #yourtable ([Id] int, [Value] varchar(6), [C...

dec 2
28 views

SELECT U.Id AS UserId, DATEDIFF(DAY, U.CreationDate, GETD...

dec 2
29 views

SELECT U.Id AS UserId, U.Reputation, DATEDIFF(DAY, U.Crea...

dec 2
133 views

WITH SortedComments AS ( SELECT PostId, Text AS Comment, ...

dec 2 Aleksejs.Zareckis
133 views

WITH SortedComments AS ( SELECT PostId, Text AS Comment, ...

dec 2 Aleksejs.Zareckis
133 views

WITH SortedComments AS ( SELECT PostId, Text AS Comment, ...

dec 2 Aleksejs.Zareckis
17 views

select t.tagName, e.body as 'Excerpt', w.body as 'WikiBody'

dec 2
81 views

WITH PostsSelected AS( SELECT pt.PostId FROM PostTags pt ...

dec 2 Aleksejs.Zareckis
81 views

WITH PostsSelected AS( SELECT pt.PostId FROM PostTags pt ...

dec 2 Aleksejs.Zareckis
280 views

SELECT * FROM Posts p JOIN PostTags pt ON p.Id = pt.PostI...

dec 2 Aleksejs.Zareckis
81 views

SELECT pt.PostId FROM PostTags pt JOIN Tags t ON pt.TagId...

dec 2 Aleksejs.Zareckis
81 views

SELECT pt.PostId FROM PostTags pt JOIN Tags t ON pt.TagId...

dec 2 Aleksejs.Zareckis
81 views

SELECT pt.PostId FROM PostTags pt JOIN Tags t ON pt.TagId...

dec 2 Aleksejs.Zareckis
81 views

SELECT t.Id from Tags t WHERE t.TagName in ('css','html')...

dec 2 Aleksejs.Zareckis
46 views

user

dec 2
29 views

user

dec 2
46 views

user

dec 2
14 views

WITH FilteredPosts AS ( SELECT p.Id, p.Title, p.Body, p.C...

dec 2
29 views

SELECT TOP 1000 u.id AS UserId, u.Reputation, u.CreationD...

dec 2
29 views

SELECT TOP 500 u.id AS UserId, u.Reputation, u.CreationDa...

dec 2
29 views

SELECT TOP 500 u.id AS UserId, u.Reputation, u.CreationDa...

dec 2
29 views

SELECT TOP 500 u.id AS UserId, u.Reputation, u.CreationDa...

dec 2
28 views

SELECT TOP 500 u.id AS UserId, u.Reputation, u.CreationDa...

dec 2
29 views

SELECT TOP 500 u.id AS UserId, u.Reputation, u.CreationDa...

dec 2
15 views

SELECT TOP 500 u.id AS UserId, u.Reputation, u.CreationDa...

dec 2
29 views

SELECT TOP 500 u.id AS UserId, u.Reputation, u.CreationDa...

dec 2
28 views

SELECT TOP 500 u.id AS UserId, u.Reputation, u.CreationDa...

dec 2
29 views

SELECT TOP 500 u.id AS UserId, u.Reputation, u.CreationDa...

dec 2
29 views

SELECT TOP 500 u.id AS UserId, u.Reputation, u.CreationDa...

dec 2
29 views

SELECT TOP 500 u.id AS UserId, u.Reputation, u.CreationDa...

dec 2
29 views

SELECT TOP 500 u.id AS UserId, u.Reputation, u.CreationDa...

dec 2
15 views

select top 3000 tagname from tags Order by "count" DESC;

dec 2
16 views

select users.id, DATEDIFF(ss, users.creationdate, CURRENT...

dec 2
29 views

select users.id, DATEDIFF(ss, users.creationdate, CURRENT...

dec 2
28 views

select users.id, DATEDIFF(ss, users.creationdate, CURRENT...

dec 2
15 views

select users.id, DATEDIFF(ss, users.creationdate, CURRENT...

dec 2
15 views

select users.id, DATEDIFF(ss, users.creationdate, CURRENT...

dec 2
16 views

select users.id, DATEDIFF(ss, users.creationdate, CURRENT...

dec 2
15 views

select users.id, DATEDIFF(ss, users.creationdate, CURRENT...

dec 2
15 views

select users.id, DATEDIFF(ss, users.creationdate, CURRENT...

dec 2
29 views

SELECT Top 500 p.id AS PostId, p.PostTypeId, p.Score, p.c...

dec 2
28 views

SELECT Top 500 p.id AS PostId, p.PostTypeId, p.Score, p.c...

dec 2
28 views

SELECT TOP 200 p.id AS PostId, p.PostTypeId, p.Score, p.c...

dec 2
28 views

SELECT TOP 200 p.id AS PostId, p.PostTypeId, p.Score, p.c...

dec 2
15 views

select p.id as PostId, p.PostTypeId, p.Score, p.closeddate,

dec 2
28 views

select p.id as PostId, p.PostTypeId, p.Score, p.closeddate,

dec 2
28 views

select p.id as PostId, p.PostTypeId, p.Score, p.closeddate,

dec 2
28 views

select p.id as PostId, p.PostTypeId, p.Score, p.closeddate,

dec 2
29 views

select p.id as PostId, p.PostTypeId, p.Score, p.closeddate,

dec 2
15 views

SELECT Users.Id AS UserId, Users.DisplayName, Users.Reput...

dec 2
597 views

SELECT p.Id, p.Tags, p.Title, p.Body as Questions_Body, p...

dec 2 jon.doe46307
597 views

SELECT p.Id, p.Tags, p.Title, p.Body as Questions_Body, p...

dec 2 jon.doe46307
597 views

SELECT p.Id, p.Tags, p.Title, p.Body as Questions_Body, p...

dec 2 jon.doe46307

30 50 100 per page