1

Please login or register to vote for this query.

(click on this box to dismiss)

NOMBRE DE VUES

Q&A for designers and implementers of computer programming languages

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 10 23 Florian.Ferrere