Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

0 views

select Id, DisplayName, ProfileImageUrl, EmailHash, Creat...

apr 20 nikitinippolit98
0 views

SELECT distinct * FROM Posts WHERE ClosedDate is not null...

apr 20
3 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

apr 20
3 views

select Id, DisplayName, ProfileImageUrl, EmailHash, Creat...

apr 20 nikitinippolit98
4 views

SELECT TOP 1000 Id AS [Post Link], OwnerUserId as [User ...

apr 20
10 views

Most controversial posts on the site

apr 20
11 views

Most controversial posts on the site

apr 20
10 views

Most controversial posts on the site

apr 20
11 views

Most controversial posts on the site

apr 20
7 views

SELECT PostId as [Post Link], Text, CreationDate FROM Com...

apr 20
7 views

SELECT PostId as [Post Link], Text, CreationDate FROM Com...

apr 20
7 views

SELECT PostId as [Post Link], Text, CreationDate FROM Com...

apr 20
9 views

select * from Posts where Title like '%cord19%';

apr 20
9 views

select * from Posts where Title like 'cord%';

apr 20
9 views

select * from Posts where Title like '%condiv%';

apr 20
10 views

select * from Posts where Title like '%Paradox Sql Loca...

apr 20
10 views

select * from Posts where Title like '%codiv%';

apr 20
10 views

select * from Posts where Title like 'sars%';

apr 20
10 views

select * from Posts where title like 'sars%';

apr 20
10 views

select * from Posts where title like '%sars cov%';

apr 20
11 views

select * from Posts where title like '%sars%';

apr 20
11 views

select * from Posts where title like '%sars%cov%2%';

apr 20
11 views

select * from Posts where title like '%sars cov 2%';

apr 20
11 views

select * from Posts where title like '%sars-cov-2%';

apr 20
11 views

select * from Posts where Body like '%pandemic%';

apr 20
11 views

SELECT ROUND(Reputation, 2) AS 'Reputation', LOG(COUNT(*)...

apr 20
11 views

SELECT distinct * FROM Posts WHERE ClosedDate is not null...

apr 20
7 views

SELECT PostId as [Post Link], Text, CreationDate FROM Com...

apr 20
7 views

SELECT PostId as [Post Link], Text, CreationDate FROM Com...

apr 20
7 views

SELECT PostId as [Post Link], Text, CreationDate FROM Com...

apr 20
11 views

SELECT PostId as [Post Link], Text, CreationDate FROM Com...

apr 20
1

182 views

Posts closed by the given user

apr 20 Martin20528
20 views

a

apr 20
13 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

apr 20
21 views

a

apr 20
20 views

a

apr 20
13 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

apr 20
13 views

select * from Posts where Body like '%coronavirus%';

apr 20
13 views

select * from Posts where Title like '%sars-cov-2%';

apr 20
13 views

select * from Posts where Title like '%pandemic%';

apr 20
13 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

apr 20
13 views

select * from Posts where Title like '%sarscov2%';

apr 20
14 views

select Id, DisplayName, ProfileImageUrl, EmailHash, Creat...

apr 20 nikitinippolit98
13 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

apr 20
13 views

select * from Posts where Title like 'ncov%';

apr 20
13 views

select * from Posts where Title like '%2019-ncov%';

apr 20
13 views

CREATE TABLE #yt ([Store] int, [Week] int, [xCount] int,[...

apr 20
13 views

select * from Posts where Title like '%coronavirus%';

apr 20
11 views

select * from Posts where Title like '%coronavirus%';

apr 20
11 views

select * from Posts where Title like '%coronavirus%';

apr 20
11 views

select * from Posts where Title like '%coronavirus%';

apr 20
11 views

select * from Posts where Title like '%coronavirus%';

apr 20
10 views

select * from Posts where Title like '%coronavirus%';

apr 20
10 views

select * from Posts where Title like '%coronavirus%';

apr 20
10 views

select * from Posts where Title like '%coronavirus%';

apr 20
10 views

select * from Posts where Title like '%coronavirus%';

apr 20
10 views

select * from Posts where Title like '%coronavirus%';

apr 20
9 views

select * from Posts where Title like '%coronavirus%';

apr 20
11 views

select * from Posts where Title like '%coronavirus%';

apr 20
9 views

select * from Posts where Title like '%coronavirus%';

apr 20
9 views

select * from Posts where Title like '%coronavirus%';

apr 20
13 views

select * from Posts where Title like '%coronavirus%';

apr 20
13 views

select * from Posts where Title like '%coronavirus%';

apr 20
13 views

select * from Posts where Title like '%coronavirus%';

apr 20
13 views

select * from Posts where Title like '%coronavirus%';

apr 20
13 views

select * from Posts where Title like '%coronavirus%';

apr 20
13 views

select * from Posts where Title like '%coronavirus%';

apr 20
12 views

select Id, DisplayName, ProfileImageUrl, EmailHash, Creat...

apr 20 nikitinippolit98
12 views

select Id, DisplayName, ProfileImageUrl, EmailHash, Creat...

apr 20 nikitinippolit98
12 views

select Id, DisplayName, ProfileImageUrl, EmailHash, Creat...

apr 20 nikitinippolit98
13 views

select Id, DisplayName, ProfileImageUrl, EmailHash, Creat...

apr 20 nikitinippolit98
13 views

select Id, DisplayName, ProfileImageUrl, EmailHash, Creat...

apr 20 nikitinippolit98
12 views

Select u1.id AS QuestionUserId, u1.Reputation As Question...

apr 20
12 views

select * from Posts where Body like '%coronavirus%';

apr 20
13 views

Select u1.id AS QuestionUserId, p1.id AS QuestionId, p1.b...

apr 20
23 views

eklf

apr 20
13 views

SELECT distinct * FROM Posts WHERE ClosedDate is not null...

apr 20
13 views

SELECT distinct * FROM Posts WHERE ClosedDate is not null...

apr 20
12 views

SELECT distinct * FROM Posts WHERE ClosedDate is not null...

apr 20
10 views

CREATE TABLE #yt ( [Store] int, [Week] int, [xCount] int );

apr 20
10 views

CREATE TABLE #yt ( [Store] int, [Week] int, [xCount] int );

apr 20
10 views

CREATE TABLE #yt ([Store] int, [Week] int, [xCount] int) ;

apr 20
14 views

select * from Tags where lower("TagName") like '%covid%';

apr 20
12 views

Select u.id AS UserId, p1.id AS QuestionId, p1.body AS Qu...

apr 20
13 views

Select u.id AS UserId, p1.id AS QuestionId, p1.body AS Qu...

apr 20
13 views

Select u.id AS UserId, p1.id AS QuestionId, p1.body AS Qu...

apr 20
12 views

select Id, DisplayName, ProfileImageUrl, EmailHash, Creat...

apr 20 nikitinippolit98
12 views

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

apr 20
12 views

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

apr 20
13 views

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

apr 20
13 views

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

apr 20
13 views

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

apr 20
12 views

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

apr 20
13 views

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

apr 20
13 views

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

apr 20
13 views

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

apr 20
12 views

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

apr 20
12 views

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

apr 20
11 views

SELECT TOP 1000 Id AS [Post Link], OwnerUserId as [User L...

apr 20
11 views

SELECT TOP 1000 Id AS [Post Link], OwnerUserId as [User L...

apr 20
13 views

SELECT TOP 1000 Id AS [Post Link], OwnerUserId as [User L...

apr 20
12 views

SELECT TOP 1000 Id AS [Post Link], OwnerUserId as [User ...

apr 20
12 views

SELECT TOP 500 PostId [Post Link], CreationDate, Text FRO...

apr 20
12 views

SELECT TOP 500 PostId [Post Link], CreationDate, Text FRO...

apr 20
12 views

SELECT TOP 500 PostId [Post Link], CreationDate, Text FRO...

apr 20
12 views

SELECT TOP 500 PostId [Post Link], CreationDate, Text FRO...

apr 20
12 views

SELECT TOP 500 PostId [Post Link], CreationDate, Text FRO...

apr 20
12 views

SELECT TOP 500 PostId [Post Link], CreationDate, Text FRO...

apr 20
12 views

SELECT TOP 500 PostId [Post Link], CreationDate, Text FRO...

apr 20
12 views

SELECT TOP 500 PostId [Post Link], CreationDate, Text FRO...

apr 20
12 views

SELECT TOP 500 PostId [Post Link], CreationDate, Text FRO...

apr 20
12 views

SELECT TOP 500 PostId [Post Link], CreationDate, Text FRO...

apr 20
12 views

SELECT TOP 500 PostId [Post Link], CreationDate, Text FRO...

apr 20
12 views

SELECT TOP 500 PostId [Post Link], CreationDate, Text FRO...

apr 20
21 views

Hit and Run -- Version 2

apr 20
22 views

Hit and Run -- Version 2

apr 20
12 views

select * from Posts where Body like '%covid%';

apr 20
12 views

select * from Posts where Body like '%covid%';

apr 20
14 views

select * from Posts where Body like '%covid%';

apr 20
12 views

apr 20
11 views

/*select name from master.sys.databases set rowcount 0 s...

apr 20
10 views

select name from master.sys.databases

apr 20
10 views

use master select TABLE_NAME from INFORMATION_SCHEMA.TABLES

apr 20
10 views

use master select * from spt_values

apr 20
10 views

use master select TABLE_NAME from INFORMATION_SCHEMA.TABLES

apr 20
11 views

select name from master.sys.databases

apr 20
10 views

use msdb select * from fn_my_permissions(NULL, 'server')

apr 20
10 views

CREATE TABLE #yt ([Store] int, [Week] int, [xCount] int) ;

apr 20
10 views

use msdb select * from fn_my_permissions(NULL, 'database')

apr 20
10 views

CREATE TABLE #yt ([Store] int, [Week] int, [xCount] int) ;

apr 20
10 views

use msdb select TABLE_NAME from INFORMATION_SCHEMA.TABLES

apr 20
10 views

use msdb

apr 20
10 views

use msdb select * from backupfile

apr 20
10 views

use msdb select TABLE_NAME from INFORMATION_SCHEMA.TABLES

apr 20
10 views

use msdb

apr 20
11 views

select name from master.sys.databases

apr 20
12 views

select db_name() select name from master.sys.databases

apr 20

30 50 100 per page

1,700,419

queries

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

57 questions

126 answers

217 comments

81 tags

apr 18 most recent