Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

49 views

SELECT Users.Id AS UserId, Users.Reputation, DATEDIFF(DAY...

dec 1 jon.doe45883
49 views

SELECT TOP 200 -- Use TOP to limit the number of results ...

dec 1 jon.doe45883
12 views

SELECT DISTINCT u.displayname FROM users u WHERE (LOWER(u...

dec 1
280 views

WITH DayPostsCounts AS( SELECT CONVERT(DATE, p.CreationDa...

dec 1 Aleksejs.Zareckis
12 views

SELECT DISTINCT u.displayName FROM users u WHERE u.locati...

dec 1
12 views

SELECT DISTINCT u.displayName FROM users u WHERE LOWER(u....

dec 1
14 views

SELECT u.Reputation FROM Users u

dec 1
13 views

SELECT u.Id AS UserId, u.Reputation FROM Users u ORDER BY...

dec 1
24 views

WITH DayPostsCounts AS( SELECT CONVERT(DATE, p.CreationDa...

dec 1
13 views

SELECT Reputation, COUNT(*) AS UserCount FROM Users GROUP...

dec 1
13 views

SELECT u.DisplayName, u.Id, u.Reputation, u.CreationDate ...

dec 1
28 views

flutter

dec 1
39 views

flutter

dec 1
34 views

flutter

dec 1
31 views

flutter

dec 1
13 views

SELECT u.Id AS UserId, u.DisplayName, COUNT(c.Id) AS Tota...

dec 1
14 views

SELECT u.Id AS UserId, u.DisplayName, COUNT(p.Id) AS Tota...

dec 1
280 views

SELECT CONVERT(DATE, p.CreationDate) AS CDate, t.TagName,...

dec 1 Aleksejs.Zareckis
14 views

SELECT t.TagName, CONVERT(DATE, p.CreationDate) AS CDate,...

dec 1
24 views

SELECT t.TagName, CONVERT(DATE, p.CreationDate) AS CDate,...

dec 1
22 views

SELECT t.TagName, CONVERT(DATE, p.CreationDate) AS CDate,...

dec 1
21 views

SELECT t.TagName, CONVERT(DATE, p.CreationDate) AS CDate,...

dec 1
15 views

SELECT t.TagName, CONVERT(DATE, p.CreationDate) AS CDate,...

dec 1
24 views

with cte_ranks as ( select id, rank() over(order by Reput...

dec 1
133 views

SELECT TOP 5 pt.TagId, COUNT(pt.PostId) AS PostCount FROM...

dec 1 Aleksejs.Zareckis
25 views

select count(*) as number_posts, max(Score) as maximum_sc...

dec 1
13 views

select count(*) from posts

dec 1
25 views

select count(*) from posts

dec 1
24 views

select count(*) from posts

dec 1
173 views

Indexes for SO

dec 1 davidalayachew
173 views

Indexes for SO

dec 1 davidalayachew
173 views

Indexes for SO

dec 1 davidalayachew
173 views

Indexes for SO

dec 1 davidalayachew
1.1k views

Just running a simple test.

dec 1 davidalayachew
1.1k views

Just running a simple test.

dec 1 davidalayachew
1.1k views

Just running a simple test.

dec 1 davidalayachew
133 views

select * from tags

dec 1 Aleksejs.Zareckis
133 views

SELECT TOP 5 t.Id, t.TagName, COUNT(pt.PostId) AS PostCount

dec 1 Aleksejs.Zareckis
173 views

Indexes for SO

dec 1 davidalayachew
173 views

Indexes for SO

dec 1 davidalayachew
173 views

Indexes for SO

dec 1 davidalayachew
173 views

Indexes for SO

dec 1 davidalayachew
173 views

Indexes for SO

dec 1 davidalayachew
173 views

Indexes for SO

dec 1 davidalayachew
1.1k views

Just running a simple test.

dec 1 davidalayachew
1.1k views

Just running a simple test.

dec 1 davidalayachew
1.1k views

Just running a simple test.

dec 1 davidalayachew
1.1k views

Just running a simple test.

dec 1 davidalayachew
1.1k views

Just running a simple test.

dec 1 davidalayachew
14 views

WITH Rankings AS ( SELECT Id, Ranking = RANK() OVER(ORDER...

dec 1
1.1k views

Just running a simple test.

dec 1 davidalayachew
16 views

WITH Rankings AS ( SELECT Id, Ranking = ROW_NUMBER() OVER...

dec 1
15 views

WITH Rankings AS ( SELECT Id, Ranking = ROW_NUMBER() OVER...

dec 1
1.1k views

Just running a simple test.

dec 1 davidalayachew
1.1k views

Just running a simple test.

dec 1 davidalayachew
7 views

SELECT COUNT(Id) FROM Posts;

dec 1
15 views

SELECT COUNT(Id) FROM Posts;

dec 1
16 views

SELECT COUNT(Id) FROM Posts;

dec 1
14 views

SELECT COUNT(Id) FROM Posts;

dec 1
8 views

SELECT TOP 1000 * FROM Users ORDER BY RAND(id);

dec 1 jon.doe45837
26 views

SELECT c.Id AS CommentId, c.PostId AS AnswerId, c.Creatio...

dec 1
26 views

SELECT c.Id AS CommentId, c.PostId AS AnswerId, c.Creatio...

dec 1
13 views

SELECT TOP 1000 a.Id AS [AnswerId], a.CreationDate AS [An...

dec 1
26 views

SELECT TOP 1000 a.Id AS [AnswerId], a.CreationDate AS [An...

dec 1
26 views

SELECT TOP 1000 a.Id AS [AnswerId], a.CreationDate AS [An...

dec 1
13 views

SELECT TOP 400 Id, Reputation, CreationDate FROM Users WH...

dec 1
24 views

SELECT top 10 u.DisplayName FROM Users u WHERE EXISTS (S...

dec 1
26 views

SELECT top 10 u.DisplayName FROM Users u WHERE EXISTS (S...

dec 1
24 views

SELECT top 10 u.DisplayName FROM Users u WHERE EXISTS (S...

dec 1
25 views

SELECT top 10 u.DisplayName FROM Users u WHERE EXISTS (S...

dec 1
26 views

SELECT top 10 u.DisplayName FROM Users u WHERE EXISTS (S...

dec 1
24 views

SELECT top 10 u.DisplayName FROM Users u WHERE EXISTS (S...

dec 1
25 views

select top 10 u.displayname from users u where exists (se...

dec 1
13 views

SELECT TOP 10 u.DisplayName FROM Users u WHERE EXISTS (SE...

dec 1
25 views

SELECT TOP 10 u.DisplayName FROM Users u WHERE EXISTS (SE...

dec 1
24 views

SELECT TOP 10 u.DisplayName FROM Users u WHERE EXISTS (SE...

dec 1
26 views

SELECT TOP 10 u.DisplayName FROM Users u WHERE EXISTS (SE...

dec 1
25 views

SELECT TOP 10 u.DisplayName FROM Users u WHERE EXISTS (SE...

dec 1
24 views

SELECT TOP 10 u.DisplayName FROM Users u WHERE EXISTS (SE...

dec 1
26 views

SELECT TOP 10 u.DisplayName FROM Users u WHERE EXISTS (SE...

dec 1
24 views

SELECT TOP 10 u.DisplayName FROM Users u WHERE EXISTS (SE...

dec 1
12 views

SELECT TOP 10 u.DisplayName FROM Users u WHERE EXISTS (SE...

dec 1
12 views

SELECT TOP 10 u.DisplayName FROM Users u WHERE EXISTS (SE...

dec 1
12 views

SELECT TOP 10 u.DisplayName FROM Users u WHERE EXISTS (SE...

dec 1
286 views

My rank in the UK

dec 1 MasterWil
286 views

My rank in the UK

dec 1 MasterWil
286 views

My rank in the UK

dec 1 MasterWil
13 views

SELECT i.name AS IndexName, o.name AS TableName, i.type_d...

dec 1
27 views

SELECT TOP 100 * FROM Users ORDER BY UpVotes DESC

dec 1 Pet237d160.The160.Spring160.Wizard
27 views

SELECT TOP 100 * FROM Users ORDER BY DownVotes DESC

dec 1 Pet237d160.The160.Spring160.Wizard
13 views

select top 3000 tagname, "count" from tags Order by "coun...

dec 1
13 views

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

dec 1
56 views

SELECT TOP 200 * FROM Comments ORDER BY Score DESC;

dec 1 Pet237d160.The160.Spring160.Wizard
56 views

SELECT * FROM Comments WHERE UserId = -1 ORDER BY Score D...

dec 1 Pet237d160.The160.Spring160.Wizard
13 views

SELECT * FROM Comments WHERE UserId = -1 ORDER BY Score D...

dec 1 Pet237d160.The160.Spring160.Wizard
1

43 views

Recently created tags which no longer exist

dec 1 Martin20528
599 views

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

dec 1 jon.doe46307
52 views

find answers to flag

dec 1
46 views

find answers to flag

dec 1
52 views

find answers to flag

dec 1
14 views

DECLARE @TagName varchar(128) = '##TagName##%' SELECT * F...

dec 1
63 views

NAADetector

dec 1
26 views

DECLARE @TagName varchar(128) = '##TagName##%' SELECT * F...

dec 1
15 views

DECLARE @TagName varchar(128) = '##TagName##%' SELECT * F...

dec 1
26 views

DECLARE @TagName varchar(128) = '##TagName##%' SELECT * F...

dec 1
27 views

select p.id as [Post Link] from posts p inner join post...

dec 1 Makyen
56 views

NAADetector

dec 1
27 views

select p.id as [Post Link] from posts p inner join post...

dec 1 Makyen
51 views

NAADetector

dec 1
46 views

NAADetector

dec 1
56 views

NAADetector

dec 1
58 views

NAADetector

dec 1
56 views

NAADetector

dec 1
59 views

NAADetector

dec 1
55 views

NAADetector

dec 1
599 views

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

dec 1 jon.doe46307
599 views

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

dec 1 jon.doe46307
599 views

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

dec 1 jon.doe46307
599 views

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

dec 1 jon.doe46307
26 views

SELECT TOP 100 Posts.Id AS PostId, Posts.Title AS TopicTi...

dec 1
599 views

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

dec 1 jon.doe46307
599 views

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

dec 1 jon.doe46307
599 views

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

dec 1 jon.doe46307
599 views

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

dec 1 jon.doe46307
599 views

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

dec 1 jon.doe46307
599 views

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

dec 1 jon.doe46307

30 50 100 per page

2,276,062

queries

Q&A about the site for active researchers, academics and students of physics

3.5k questions

6k answers

32k comments

117 tags

nov 24 most recent