0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Ubuntu users and developers

DECLARE @lastDate DATE = ( 
	select MAX(CreationDate) 
	from Posts 
)
select @lastDate

select top 10 ViewCount, Title
from Posts 
where CreationDate = @lastDate
and ViewCount > 0
order by ViewCount desc

fork query

edited jan 31 13

created mar 6 12 anonymous