1. Home
2. Questions
3. Tags
5. Users
6. Unanswered
Teams

Ask questions, find answers and collaborate at work with Stack Overflow for Teams.
Try Teams for free Explore Teams
Teams
Ask questions, find answers and collaborate at work with Stack Overflow for Teams. Explore Teams

Return to Answer

replaced http://data.stackexchange.com/ with https://data.stackexchange.com/

Source Link

edited Jan 18, 2021 at 12:13

1

Here you go with Data Explorer query Data Explorer query

SELECT TOP 100 ROW_NUMBER() OVER(ORDER BY Views DESC) AS Rank
              , ID AS [User Link]
              , Views, Reputation, Location 
FROM USERS

Output:

╔═══════╦═════════════════╦═══════════╦══════════════╦═════════════════════════╗
║ Rank  ║      User       ║    Views  ║  Reputation  ║        Location         ║
╠═══════╬═════════════════╬═══════════╬══════════════╬═════════════════════════╣
║     1 ║ Jon Skeet       ║    639947 ║       610427 ║ Reading, United Kingdom ║
║     2 ║ Eric Lippert    ║    176837 ║       249482 ║ Seattle, WA             ║
║     3 ║ Marc Gravell    ║    133054 ║       423970 ║ Forest of Dean, UK      ║
║     4 ║ Jeff Atwood     ║    122506 ║        27684 ║ El Cerrito, CA          ║
║     5 ║ BalusC          ║    115142 ║       425228 ║ Willemstad, Curaçao     ║
║     6 ║ Darin Dimitrov  ║    106748 ║       466354 ║ Sofia, Bulgaria         ║
║     7 ║ Bill the Lizard ║     82214 ║       124132 ║ Charlotte, NC           ║
║     8 ║ Hans Passant    ║     80089 ║       389208 ║ Madison, WI             ║
║     9 ║ CommonsWare     ║     75888 ║       322395 ║ Where You Least Expect  ║
║    10 ║ casperOne       ║     62554 ║        45832 ║ Brooklyn, NY            ║
║   ... ║                 ║           ║              ║                         ║
╚═══════╩═════════════════╩═══════════╩══════════════╩═════════════════════════╝

Here you go with Data Explorer query

SELECT TOP 100 ROW_NUMBER() OVER(ORDER BY Views DESC) AS Rank
              , ID AS [User Link]
              , Views, Reputation, Location 
FROM USERS

Output:

╔═══════╦═════════════════╦═══════════╦══════════════╦═════════════════════════╗
║ Rank  ║      User       ║    Views  ║  Reputation  ║        Location         ║
╠═══════╬═════════════════╬═══════════╬══════════════╬═════════════════════════╣
║     1 ║ Jon Skeet       ║    639947 ║       610427 ║ Reading, United Kingdom ║
║     2 ║ Eric Lippert    ║    176837 ║       249482 ║ Seattle, WA             ║
║     3 ║ Marc Gravell    ║    133054 ║       423970 ║ Forest of Dean, UK      ║
║     4 ║ Jeff Atwood     ║    122506 ║        27684 ║ El Cerrito, CA          ║
║     5 ║ BalusC          ║    115142 ║       425228 ║ Willemstad, Curaçao     ║
║     6 ║ Darin Dimitrov  ║    106748 ║       466354 ║ Sofia, Bulgaria         ║
║     7 ║ Bill the Lizard ║     82214 ║       124132 ║ Charlotte, NC           ║
║     8 ║ Hans Passant    ║     80089 ║       389208 ║ Madison, WI             ║
║     9 ║ CommonsWare     ║     75888 ║       322395 ║ Where You Least Expect  ║
║    10 ║ casperOne       ║     62554 ║        45832 ║ Brooklyn, NY            ║
║   ... ║                 ║           ║              ║                         ║
╚═══════╩═════════════════╩═══════════╩══════════════╩═════════════════════════╝

Here you go with Data Explorer query

SELECT TOP 100 ROW_NUMBER() OVER(ORDER BY Views DESC) AS Rank
              , ID AS [User Link]
              , Views, Reputation, Location 
FROM USERS

Output:

╔═══════╦═════════════════╦═══════════╦══════════════╦═════════════════════════╗
║ Rank  ║      User       ║    Views  ║  Reputation  ║        Location         ║
╠═══════╬═════════════════╬═══════════╬══════════════╬═════════════════════════╣
║     1 ║ Jon Skeet       ║    639947 ║       610427 ║ Reading, United Kingdom ║
║     2 ║ Eric Lippert    ║    176837 ║       249482 ║ Seattle, WA             ║
║     3 ║ Marc Gravell    ║    133054 ║       423970 ║ Forest of Dean, UK      ║
║     4 ║ Jeff Atwood     ║    122506 ║        27684 ║ El Cerrito, CA          ║
║     5 ║ BalusC          ║    115142 ║       425228 ║ Willemstad, Curaçao     ║
║     6 ║ Darin Dimitrov  ║    106748 ║       466354 ║ Sofia, Bulgaria         ║
║     7 ║ Bill the Lizard ║     82214 ║       124132 ║ Charlotte, NC           ║
║     8 ║ Hans Passant    ║     80089 ║       389208 ║ Madison, WI             ║
║     9 ║ CommonsWare     ║     75888 ║       322395 ║ Where You Least Expect  ║
║    10 ║ casperOne       ║     62554 ║        45832 ║ Brooklyn, NY            ║
║   ... ║                 ║           ║              ║                         ║
╚═══════╩═════════════════╩═══════════╩══════════════╩═════════════════════════╝

Updated records; formatted query

Source Link

edited Oct 10, 2013 at 10:50

33.7k
10
91
152

SELECT TOP 100 ROW_NUMBER() OVER(ORDER BY Views DESC) AS Rank
              , ID AS [User Link]
              , Views, Reputation, Location 
FROM USERS

SELECT TOP 100 ROW_NUMBER() OVER(ORDER BY Views DESC) AS Rank
              , ID AS [User Link]
              , Views, Reputation, Location 
FROM USERS

╔═══════╦═════════════════════════╦═════════╦═════════════╦══════════════════════════╗╔═══════╦═════════════════╦═══════════╦══════════════╦═════════════════════════╗
║ Rank  ║ User Link     User       ║   ║ Views   ║  Reputation  ║ Location        Location         ║
╠═══════╬═════════════════════════╬═════════╬═════════════╬══════════════════════════╣╠═══════╬═════════════════╬═══════════╬══════════════╬═════════════════════════╣
║ 1    1 ║ Jon Skeet          ║    639947 ║ 195496  ║ 566017     610427 ║ Reading, United Kingdom  ║
║ 2    2 ║ Marc Gravell  Eric Lippert    ║    176837 ║ 49421   ║ 392057     249482 ║ Forest of DeanSeattle, UKWA       ║
║ 3     ║ Jeff Atwood 
║     3 ║ Marc Gravell    ║ 41072   133054 ║ 25815      423970 ║ El Cerrito, CA  Forest of Dean, UK      ║
║ 4    4 ║ Eric Lippert Jeff Atwood     ║    122506 ║ 36676   ║ 224983     27684 ║ Seattle, WA  El Cerrito, CA          ║
║ 5    5 ║ Joel Spolsky  BalusC          ║ 32408   115142 ║ 19569      425228 ║ New YorkWillemstad, NY        Curaçao     ║
║ 6    6 ║ Alex Martelli   Darin Dimitrov  ║    106748 ║ 26717   ║ 260640     466354 ║ Palo AltoSofia, CA   Bulgaria         ║
║ 7    7 ║ cletus         Bill the Lizard ║     82214 ║ 23156   ║ 218278     124132 ║ New YorkCharlotte, NY  NC           ║
║ 8    8 ║ JohannesHans SchaubPassant - litb  ║ 19393    80089 ║ 202424      389208 ║ GiessenMadison, Germany  WI       ║
║ 9     ║ Mehrdad Afshari 
║     9 ║ CommonsWare ║ 19160   ║ 162443     75888 ║ California        322395 ║ Where You Least Expect  ║
║ 10   10 ║ BillcasperOne the Lizard     ║    ║ 1822962554 ║  ║ 112464     45832 ║ CharlotteBrooklyn, NCNY            ║
║   ...   ║                       ║  ║         ║             ║ ║                         ║
╚═══════╩═════════════════════════╩═════════╩═════════════╩══════════════════════════╝╚═══════╩═════════════════╩═══════════╩══════════════╩═════════════════════════╝

SELECT TOP 100 ROW_NUMBER() OVER(ORDER BY Views DESC) AS Rank
              , ID AS [User Link]
              , Views, Reputation, Location 
FROM USERS

╔═══════╦═════════════════════════╦═════════╦═════════════╦══════════════════════════╗
║ Rank  ║ User Link               ║ Views   ║ Reputation  ║ Location                 ║
╠═══════╬═════════════════════════╬═════════╬═════════════╬══════════════════════════╣
║ 1     ║ Jon Skeet               ║ 195496  ║ 566017      ║ Reading, United Kingdom  ║
║ 2     ║ Marc Gravell            ║ 49421   ║ 392057      ║ Forest of Dean, UK       ║
║ 3     ║ Jeff Atwood             ║ 41072   ║ 25815       ║ El Cerrito, CA           ║
║ 4     ║ Eric Lippert            ║ 36676   ║ 224983      ║ Seattle, WA              ║
║ 5     ║ Joel Spolsky            ║ 32408   ║ 19569       ║ New York, NY             ║
║ 6     ║ Alex Martelli           ║ 26717   ║ 260640      ║ Palo Alto, CA            ║
║ 7     ║ cletus                  ║ 23156   ║ 218278      ║ New York, NY             ║
║ 8     ║ Johannes Schaub - litb  ║ 19393   ║ 202424      ║ Giessen, Germany         ║
║ 9     ║ Mehrdad Afshari         ║ 19160   ║ 162443      ║ California               ║
║ 10    ║ Bill the Lizard         ║ 18229   ║ 112464      ║ Charlotte, NC            ║
║ ...   ║                         ║         ║             ║                          ║
╚═══════╩═════════════════════════╩═════════╩═════════════╩══════════════════════════╝

SELECT TOP 100 ROW_NUMBER() OVER(ORDER BY Views DESC) AS Rank
              , ID AS [User Link]
              , Views, Reputation, Location 
FROM USERS

╔═══════╦═════════════════╦═══════════╦══════════════╦═════════════════════════╗
║ Rank  ║      User       ║    Views  ║  Reputation  ║        Location         ║
╠═══════╬═════════════════╬═══════════╬══════════════╬═════════════════════════╣
║     1 ║ Jon Skeet       ║    639947 ║       610427 ║ Reading, United Kingdom ║
║     2 ║ Eric Lippert    ║    176837 ║       249482 ║ Seattle, WA             ║
║     3 ║ Marc Gravell    ║    133054 ║       423970 ║ Forest of Dean, UK      ║
║     4 ║ Jeff Atwood     ║    122506 ║        27684 ║ El Cerrito, CA          ║
║     5 ║ BalusC          ║    115142 ║       425228 ║ Willemstad, Curaçao     ║
║     6 ║ Darin Dimitrov  ║    106748 ║       466354 ║ Sofia, Bulgaria         ║
║     7 ║ Bill the Lizard ║     82214 ║       124132 ║ Charlotte, NC           ║
║     8 ║ Hans Passant    ║     80089 ║       389208 ║ Madison, WI             ║
║     9 ║ CommonsWare     ║     75888 ║       322395 ║ Where You Least Expect  ║
║    10 ║ casperOne       ║     62554 ║        45832 ║ Brooklyn, NY            ║
║   ... ║                 ║           ║              ║                         ║
╚═══════╩═════════════════╩═══════════╩══════════════╩═════════════════════════╝

Improved query and formatting

Source Link

edited May 24, 2013 at 4:22

33.7k
10
91
152

Here you go with Data Explorer Data Explorer query

SELECT TOP 10100 ROW_NUMBER() OVER(ORDER BY Views DESC) AS Rank
              , ID AS [User Link]
              , Views, Reputation, Location 
FROM USERS
ORDER BY Views DESC

╔════════════════════════════════════════════════════════════════════╗╔═══════╦═════════════════════════╦═════════╦═════════════╦══════════════════════════╗
║ Rank  ║ User Link               ║ Views   ║ Reputation  ║ Location                 ║
╠════════════════════════════════════════════════════════════════════╣╠═══════╬═════════════════════════╬═════════╬═════════════╬══════════════════════════╣
║ 1     ║ Jon Skeet               ║ 195496  ║ 566017      ║ Reading, United Kingdom  ║
║ 2     ║ Marc Gravell            ║ 49421   ║ 392057      ║ Forest of Dean, UK       ║
║ 3     ║ Jeff Atwood             ║ 41072   ║ 25815       ║ El Cerrito, CA           ║
║ 4     ║ Eric Lippert            ║ 36676   ║ 224983      ║ Seattle, WA              ║
║ 5     ║ Joel Spolsky            ║ 32408   ║ 19569       ║ New York, NY             ║
║ 6     ║ Alex Martelli           ║ 26717   ║ 260640      ║ Palo Alto, CA            ║
║ 7     ║ cletus                  ║ 23156   ║ 218278      ║ New York, NY             ║
║ 8     ║ Johannes Schaub - litb  ║ 19393   ║ 202424      ║ Giessen, Germany         ║
║ 9     ║ Mehrdad Afshari         ║ 19160   ║ 162443      ║ California               ║
║ 10    ║ Bill the Lizard         ║ 18229   ║ 112464      ║ Charlotte, NC            ║
╚════════════════════════════════════════════════════════════════════╝║ ...   ║                         ║         ║             ║                          ║
╚═══════╩═════════════════════════╩═════════╩═════════════╩══════════════════════════╝

http://data.stackexchange.com/stackoverflow/query/115932

Here you go with Data Explorer

SELECT TOP 10 ID AS [User Link], Views, Reputation, Location 
FROM USERS
ORDER BY Views DESC

╔════════════════════════════════════════════════════════════════════╗
║ User Link               Views  Reputation Location                 ║
╠════════════════════════════════════════════════════════════════════╣
║ Jon Skeet               195496 566017     Reading, United Kingdom  ║
║ Marc Gravell            49421  392057     Forest of Dean, UK       ║
║ Jeff Atwood             41072  25815      El Cerrito, CA           ║
║ Eric Lippert            36676  224983     Seattle, WA              ║
║ Joel Spolsky            32408  19569      New York, NY             ║
║ Alex Martelli           26717  260640     Palo Alto, CA            ║
║ cletus                  23156  218278     New York, NY             ║
║ Johannes Schaub - litb  19393  202424     Giessen, Germany         ║
║ Mehrdad Afshari         19160  162443     California               ║
║ Bill the Lizard         18229  112464     Charlotte, NC            ║
╚════════════════════════════════════════════════════════════════════╝

http://data.stackexchange.com/stackoverflow/query/115932

Here you go with Data Explorer query

SELECT TOP 100 ROW_NUMBER() OVER(ORDER BY Views DESC) AS Rank
              , ID AS [User Link]
              , Views, Reputation, Location 
FROM USERS

╔═══════╦═════════════════════════╦═════════╦═════════════╦══════════════════════════╗
║ Rank  ║ User Link               ║ Views   ║ Reputation  ║ Location                 ║
╠═══════╬═════════════════════════╬═════════╬═════════════╬══════════════════════════╣
║ 1     ║ Jon Skeet               ║ 195496  ║ 566017      ║ Reading, United Kingdom  ║
║ 2     ║ Marc Gravell            ║ 49421   ║ 392057      ║ Forest of Dean, UK       ║
║ 3     ║ Jeff Atwood             ║ 41072   ║ 25815       ║ El Cerrito, CA           ║
║ 4     ║ Eric Lippert            ║ 36676   ║ 224983      ║ Seattle, WA              ║
║ 5     ║ Joel Spolsky            ║ 32408   ║ 19569       ║ New York, NY             ║
║ 6     ║ Alex Martelli           ║ 26717   ║ 260640      ║ Palo Alto, CA            ║
║ 7     ║ cletus                  ║ 23156   ║ 218278      ║ New York, NY             ║
║ 8     ║ Johannes Schaub - litb  ║ 19393   ║ 202424      ║ Giessen, Germany         ║
║ 9     ║ Mehrdad Afshari         ║ 19160   ║ 162443      ║ California               ║
║ 10    ║ Bill the Lizard         ║ 18229   ║ 112464      ║ Charlotte, NC            ║
║ ...   ║                         ║         ║             ║                          ║
╚═══════╩═════════════════════════╩═════════╩═════════════╩══════════════════════════╝

added 1075 characters in body

Source Link

edited May 23, 2013 at 13:30

33.7k
10
91
152

Loading

Source Link

created May 23, 2013 at 13:24

33.7k
10
91
152

Loading