Select * or SELECT alias.* are also supported, but if you have columns with non supported characters, they will not be validated, and will cause the query to misbehave.
TARGIT InMemory Database is designed for doing aggregative queries quickly.
Non Aggregative queries will run and will also continue to execute in full if you select a large number of records from them.
In our testing, tables with millions of records is not a problem, but if you pass a query that performs a SELECT * from a table with hundreds of millions records, internally it goes through the process of creating the table from scratch and columnizing it, thereby possibly running out of memory.
Note: Order By requires the relevant field/ expression as an argument rather than a column number.
WHERE FREIGHT > 50
MAX(e1.FirstName +' '+ e1.LastName) AS EmpName,
MAX(OrderDate) AS OrderDate,
SUM(d1.UnitPrice) AS ‘Price’,
SUM(d1.quantity) as QTY
FROM Orders AS h1
INNER JOIN [Order Details] as d1 ON d1.OrderID = h1.OrderID
LEFT JOIN Employees AS e1 ON e1.EmployeeID = h1.EmployeeID WHERE CustomerID = 'FRANK'
GROUP BY d1.OrderID
HAVING QTY >= 40
ORDER BY MAX(e1.FirstName +' '+ e1.LastName)