So basically I'm trying to find all the Users which are under the certain Manager.

When I run query "SELECT Id,Name FROM User WHERE ManagerId=xxxxxxx" I get just the names but no IDs.

The query "SELECT Id FROM User" yields an array of nulls. I'm doing this via API using Sandbox environment and credentials of a user who is a System Admin.

Is this a bug? Has anybody experienced this before?

Hi guys,

I'm trying to write a query selecting top 5 sales persons, this doesn't work:

SELECT SUM(Amount)AmountSum,OwnerId FROM Opportunity GROUP BY OwnerId ORDER BY AmountSum DESC LIMIT 5

What is the way to sort by aggregate column? I've been searching for almost an hour now but I'm nowhere closer. 

Hi guys,

I'm trying to write a query selecting top 5 sales persons, this doesn't work:

SELECT SUM(Amount)AmountSum,OwnerId FROM Opportunity GROUP BY OwnerId ORDER BY AmountSum DESC LIMIT 5

What is the way to sort by aggregate column? I've been searching for almost an hour now but I'm nowhere closer.