Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

1 view

DECLARE @UserId int = ##UserId?209103## SELECT DATEADD(Y...

dec 4
2 views

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

dec 4
2 views

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

dec 4
3 views

SELECT TOP 10 * FROM posts;

dec 4
3 views

SELECT * FROM posts;

dec 4
15 views

select u.Reputation, u.DisplayName, u.WebsiteUrl, u.Locat...

dec 4
15 views

select u.Reputation, u.DisplayName, u.WebsiteUrl, u.Locat...

dec 4
18 views

select u.AboutMe from users u where AboutMe like '%php%';

dec 4
16 views

select u.AboutMe from users u

dec 4
17 views

SELECT DISTINCT Users.DisplayName, Users.Location, Users....

dec 4
21 views

select * from Tags where TagName like '%symfony%';

dec 4
20 views

select distinct Users.DisplayName, Users.Location, Use...

dec 4
21 views

select * from Tags where TagName like '%php%';

dec 4
21 views

select distinct Users.DisplayName, Users.Location, Use...

dec 4
22 views

select * from Tags

dec 4
11 views

select distinct Users.DisplayName, Users.Location, Use...

dec 4
21 views

select distinct Users.DisplayName, Users.Location, Use...

dec 4
20 views

select distinct Users.DisplayName, Users.Location, Use...

dec 4
17 views

select distinct Users.DisplayName, Users.Location, Use...

dec 4
20 views

select * from users u where location like '%Minsk%';

dec 4
11 views

select * from users u

dec 4
20 views

select * from users u

dec 4
22 views

select * from users u

dec 4
21 views

select * from users u

dec 4
21 views

select * from users u

dec 4
16 views

select * from users u

dec 4
18 views

select * from users u

dec 4
15 views

select * from users u

dec 4
15 views

select * from users u

dec 4
144 views

WITH TopTags AS ( SELECT tagid FROM posttags GROUP BY tagid

dec 4 Janis123
30 views

select count(1) from ( select pt1.postid from posttags pt...

dec 4 Janis123
30 views

select top(5) tag_combo, count(1) from (select pttg.PostI...

dec 4 Janis123
144 views

WITH TopTags AS ( SELECT top 100 tagid FROM posttags GROU...

dec 4 Janis123
144 views

WITH TopTags AS ( SELECT top 5 pt.tagId, t.tagname, COUNT...

dec 4 Janis123
13 views

select table_name as [Table(Links to Sample Data)], --sam...

dec 4
144 views

WITH TopTags AS ( SELECT top 5 pt.tagId, t.tagname, COUNT...

dec 4 Janis123
144 views

WITH TopTags AS ( SELECT top 5 pt.tagId, t.tagname, COUNT...

dec 4 Janis123
144 views

WITH TopTags AS ( SELECT top 5 pt.tagId, t.tagname, COUNT...

dec 4 Janis123
144 views

WITH TopTags AS ( SELECT top 5 pt.tagId, t.tagname, COUNT...

dec 4 Janis123
30 views

with calendar as ( select TOP(DATEDIFF(day, '2023-12-31',...

dec 4 Janis123
144 views

WITH TopTags AS ( SELECT top 5 pt.tagId, t.tagname, COUNT...

dec 4 Janis123
144 views

WITH TopTags AS ( SELECT top 5 pt.tagId, t.tagname, COUNT...

dec 4 Janis123
144 views

WITH TopTags AS ( SELECT top 5 pt.tagId, t.tagname, COUNT...

dec 4 Janis123
66 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 4 Bowen.Zhou
66 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 4 Bowen.Zhou
144 views

select postid, count(1) from comments c where c.creationd...

dec 4 Janis123
66 views

select * from comments

dec 4 Bowen.Zhou
66 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 4 Bowen.Zhou
66 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 4 Bowen.Zhou
66 views

select * from comments

dec 4 Bowen.Zhou
144 views

WITH aggregated_votes AS ( SELECT PostId, COUNT(CASE WHEN...

dec 4 Janis123
66 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 4 Bowen.Zhou
19 views

select id,name from closereasontypes

dec 4
144 views

WITH aggregated_votes AS ( SELECT PostId, COUNT(CASE WHEN...

dec 4 Janis123
144 views

WITH aggregated_votes AS ( SELECT PostId, COUNT(CASE WHEN...

dec 4 Janis123
144 views

select top 5 p.Id, p.tags from posts p inner join ( selec...

dec 4 Janis123
144 views

select p.Id, count(1) from posts p inner join ( select Po...

dec 4 Janis123
144 views

select p.Id, p.tags from posts p inner join ( select PostId

dec 4 Janis123
22 views

select id,name from votetypes

dec 4
20 views

select id,name from posttypes

dec 4
11 views

select id,name from posthistorytypes

dec 4
20 views

select id,name from posthistorytypes

dec 4
22 views

select id,name from posthistorytypes

dec 4
19 views

select id,name from posthistorytypes

dec 4

30 50 100 per page