Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

1 view

CREATE table #yourtable ([Id] int,[No] int, [Value] varch...

jan 18
1 view

select title,body,tags from Posts where tags like '%javas...

jan 18
1 view

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

jan 18
1 view

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

jan 18
1 view

select title,body,tags from Posts where tags like '%javas...

jan 18
1 view

select title,body,tags from Posts where tags like '%javas...

jan 18
1 view

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

jan 18
1 view

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

jan 18
10 views

Test Query

jan 18
6 views

SELECT q.id, q.Title, q.Body q_body,q.CreationDate, q.Tag...

jan 18
12 views

test

jan 18
12 views

test

jan 18
12 views

test

jan 18
12 views

test

jan 18
14 views

test

jan 18
7 views

SELECT q.id, q.Title, q.Body q_body,q.CreationDate, q.Tag...

jan 18
8 views

SELECT q.id, q.Title, q.Body q_body,q.CreationDate, q.Tag...

jan 18
8 views

SELECT * FROM Comments WHERE Userid = 324082

jan 18
17 views

View comments sorted by score

jan 18
9 views

SELECT q.id, q.Title, q.Body q_body,q.CreationDate, q.Tag...

jan 18
2

609 views

Comments with highest score

jan 18 Martin20528
9 views

SELECT DISTINCT id FROM Posts ORDER BY id DESC

jan 18
9 views

SELECT DISTINCT id FROM Posts

jan 18
9 views

SELECT DISTINCT id FROM Posts

jan 18
18 views

test

jan 18
18 views

test

jan 18
18 views

test

jan 18
14 views

test

jan 18
12 views

test

jan 18
1

19 views

Top comments between two dates

jan 18 Martin20528
1

19 views

Top comments between two dates

jan 18 Martin20528
10 views

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

jan 18
10 views

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

jan 18
10 views

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

jan 18
10 views

select * from posts

jan 18
10 views

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

jan 18
10 views

select posttypeid from posts

jan 18
9 views

select * from posts

jan 18
9 views

select count(distinct id) as no_of_posts from posts where...

jan 18
9 views

select * from ReviewTaskResults

jan 18
9 views

select count(distinct id) as no_of_posts from posts where...

jan 18
9 views

select count(distinct id) as no_of_posts from posts where...

jan 18
10 views

select count(distinct id) as no_of_posts from posts where...

jan 18
10 views

select count(distinct id) as no_of_posts from posts where...

jan 18
9 views

select top 100 * from posts left join users on posts.Own...

jan 18
9 views

select top 10 * from posts left join users on posts.Owne...

jan 18
9 views

with cte as (select tagid, count(distinct postid) postcount

jan 18
10 views

with cte as (select tagid, count(distinct postid) postcount

jan 18
10 views

with cte as (select tagid, count(distinct postid) postcount

jan 18
11 views

with cte as (select id from posts where year(creationdate...

jan 18
11 views

select * from ReviewRejectionReasons

jan 18
9 views

select * from ReviewRejectionReasons

jan 18
11 views

select tagid, count(distinct postid) from posttags group ...

jan 18
11 views

select top 100 * from posttags order by postid

jan 18
11 views

select top 100 * from posttags

jan 18
12 views

select top 100 tagname, count(distinct p.id) tagcount fro...

jan 18
11 views

select top 100 * from tags

jan 18
11 views

select top 100 * from posts

jan 18
11 views

WITH CTE AS (SELECT postid, count(distinct id) AS postcount

jan 18
11 views

WITH CTE AS (SELECT postid, count(distinct id) AS postcount

jan 18

30 50 100 per page

1,867,409

queries

Q&A for linguists, teachers and students of the Korean language

1.6k questions

2.8k answers

5.3k comments

116 tags

jan 16 most recent