0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for spacecraft operators, scientists, engineers, and enthusiasts

-- questions
select top 5 * from Posts where PostTypeId = 1 and DeletionDate is null
order by Score desc 

select top 5 * from Posts where PostTypeId = 1 and DeletionDate is null
order by Score asc 

-- answers
select top 5 * from Posts where PostTypeId = 2 and DeletionDate is null
order by Score desc 

select top 5 * from Posts where PostTypeId = 2 and DeletionDate is null
order by Score asc

fork query

edited mar 2

created may 26 16 anonymous