0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for pro webmasters

-- Enter Query Title
-- Enter Query Description
select top (2) * from posts;
select top (2) * from users;

--section 5- 5.	For each user, determine whether he accessed the system
--in the last 60 days. Display the user’s id, DisplayName, and the value
--‘Active’ / ‘Not Active’ according to the user’s last access date.
--Display only the 200 with the latest access dates.

--select max(LastAccessDate) from users;
select cast(getdate() as date);

fork query

edited nov 12 user28265485

created nov 12 anonymous