Cacher is the code snippet organizer for pro developers

select top 1 *
from ba.userSession
where logoutdate is null
order by logondate desc

select top 10 *
from ra.ItemRetailStore
where Status != 'I' and RetailStoreId = 'S0001'
order by lastPriceChange desc