-- -- Find top 10 "sales amount" and the employee who made the sales -- od := [Order Details] summary sum( od.UnitPrice * od.Quantity * (1 - od.Discount) ) by OrderID |> ord := Orders filter ord.OrderID = od.OrderID column ord.OrderID, ord.ShippedDate, ord.EmployeeID, od.summary1 SaleAmount |> emp := Employees filter emp.EmployeeID = ord.EmployeeID column emp.Country, emp.LastName, emp.FirstName, ord.OrderID, ord.ShippedDate, ord.SaleAmount sort ord.SaleAmount - top 10;
  • This section gives a good introduction to PipeSQL.
    Click on the above topics to view details and generated SQL examples.

  • Please note that, due to demo version, most features such as Save, Download, Source Search are not available at this moment.

    Please do contact me for setting up a Cloud based (Hybrid) solution which enables you to fully utilize the APP by using in-house business databases.
    Currently, PipeSQL's backend is running on Python 2.7 and hosted in azure cloud.

    I need a Cloud based(Hybrid) APP

Copyright © 2014 pipesql.com . All Right Reserved