1

Please login or register to vote for this query.

(click on this box to dismiss)

p.ViewCount AS 'Nombre de vues' 6 FROM Posts p

Q&A for those who study, teach, research and apply economics and econometrics

SELECT
  p.OwnerDisplayName AS 'auteur',
  p.Title AS 'titre',
  pt.Name AS 'Type de post',
  p.ViewCount AS 'Nombre de vues'
FROM Posts p
JOIN PostTypes pt
ON p.PostTypeId = pt.Id
WHERE p.ViewCount = (
    SELECT MAX(p.ViewCount)
    FROM Posts p);

fork query

edited jun 10 2024

created feb 13 23 Florian.Ferrere