A table-based query starts with, or references, a table in the first part of the query. This defines the scope of the query and determines what initial result set gets returned or passed on to subsequent parts of the query for further filtering or processing. In the previous example query that we walked through, a table of the name Heartbeat is used to define the scope of the query.
Queries can be written in various ways to arrive at the same result, provided that the query is syntactically correct. For instance, the following query is used to return an aggregated count of all records in the table with the name of Heartbeat:
Heartbeat| summarize AggregatedValue = count() by Type
This query can also be written in the following ...