SELECT top 700 u.id, u.DisplayName, u.LastAccessDate, C...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Martial Arts Meta

Q&A for students and teachers of all martial arts

SELECT  top 700  u.id,
                	      u.DisplayName,
                	      u.LastAccessDate,
            	      CASE
              	      	WHEN datediff(day, LastAccessDate, getdate()) <= 60 
THEN 'Active'
              		ELSE 'Not Active'
            	      END AS is_active
FROM users u
ORDER BY u.id DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results