SELECT TOP 4 *
    FROM [Content] AS at
    WHERE 1=1
    	AND at.[ParentID] = 16	AND at.[Active] = 'yes'
    ORDER BY at.[Rank]
    
  • Jungpana